Components 60

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

XLShortcut_EnableDisable

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


Page2Setting

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


SheetDelete_ANmar

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


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 ...


List_Load + List_Save

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


sortArray

Sort an array of Numeric values, simple straightforward Originally from ...


Shapes-Macros

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


IIF

[Not tested] Works the same as it's VB IIF equivalent. IIf will coerce an ...


FindVBAObject

Finds specific VBA object in VBE project User need to setup to trust VBA ...