Components 198

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

Sorted from new to old.

WorkbookNew_ANmar

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

2018Aug9

WorkbookClose_ANmar

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

2018Aug9

List_Load + List_Save

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

2018Jul26

sortArray

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

2018Jul25

Shapes-Macros

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

2018Jul9

IIF

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

2018Jul7

FindVBAObject

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

2018Jul6

oShellRun1

Runs a WScript.Shell command with wait until finish and returns 0, 1, 2 or -1 ...

2018Jul6

SortArea5

Sort range or area by 5 columns, range can be any number of columns, but the ...

2018Jul5

ServerVar

Get value of Server variable by passing variable name aVar can be any of these ...

2018Jul4

SortArea3

Sort range or area by 3 columns, range can be any number of columns, but the ...

2018Jul4

SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

2018Jul4

Sort1Col

Sorts a column in Excel, easily, with options

2018Jul4

FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

2018Jun30

CellSave (SimpleSave)

Saves value to cell without deformation and converting Used to be called ...

2018Jun26

SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

2018Jun26

1 2 ...10 ...12 13