Components 180 Controls, objects and classes, also cells, sheets, workbooks in VBA-Excel

Card image cap
SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

Card image cap
XLShortcut_EnableDisable

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

Card image cap
Page2Setting

Read content of an html online page into setting value in Excel sheet. ...

Card image cap
SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

Card image cap
CellSave_Hyperlink

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

Card image cap
FindFile_Word

Finds a file within open documents of current instance

Card image cap
WorkbookNew_ANmar

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

Card image cap
WorkbookClose_ANmar

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

Card image cap
List_Load + List_Save

Loads/Saves items from/to text file to/from listbox Also has simple adding and ...

Card image cap
sortArray

Sort an array of Numeric values, simple straightforward Edit v3 2021-09-21: ...

Card image cap
Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...

Shapes-Macros v1.0.xlsb.zip

Card image cap
IIF

Works the same as it's VB IIF equivalent. IIf will coerce an expression into ...