HTML and URL codes

Always find my self needing to know those quickly to continue working, so ...

Listbox height changing issue

Listbox in Excel sometimes have issue adjusting height to items added inside, ...

Listbox height changing issue.zip

Scrolly

Scroll a listbox Using Right-Drag. (Something VBA in Excel lacks) You might ...

scroll_Listbox.zip

XLShortcut_EnableDisable

Disables or Enables certain Excel built-in shortcut. Code has example on how ...

CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

ApplyValidation_DropDown

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

IsThere1_Remote

Checks if a file is found from a URL, finds a file in a remote server

CellSave_Hyperlink

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

FindFile_Word

Finds a file within open documents of current instance

WorkbookNew_ANmar

Creates new workbook (does not save it) and returns filename.

WorkbookClose_ANmar

Closes a workbook, checks if it is already open first, works for workbooks ...

WorkbookSaveAsk_ANmar

Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...