Components 185

Controls, objects and classes, also cells, sheets, workbooks in VBA-Excel
Sorted from new to old.
Card image
HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

Card image
MatchIf (aka VMatchIf)

The best Match I created, return 0 if not found, kind of CountIF+Match ...

Card image
WorkbookOpen_ANmar

Opens Workbook without running AutoMacros and without letting the user know ...

Card image
WaitFor + ShellWait

Tell App to wait for number of seconds and Execute command and wait for it ...

Card image
GetColumnName, ColumnName_XOffset

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

Card image
HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

Card image
ListBox_SelectedIndexes

Create list of selected items in MSForms listbox as string separated by | Or ...

Card image
Col2Combo

Reads everything in a column (starting from certain cell until blank cell is ...

Card image
FindName

Finds a name in a workbook, returns true or false

Card image
FindSheet

Finds a sheet in a workbook, if no workbook name passed, it will use ...

Card image
Multi-line Textbox focus bug

Trick to force textbox with multiple lines and scrollbars to refresh itself ...

Card image
Filter_GotoItem

Allow users to select from list box based on search terms. Have a text box and ...

Card image
ComputerSN

Reads Serial number of the system, also can be used to return System name, ...

Card image
FindIn1DArray

Returns 1 if an item found in array, 0 if not

Card image
Numbers in Textbox

Force textbox to accept numbers only. Needs adjustments to work on VB6

Card image
MoveDown + MoveUp

Moves an item in listbox up or down Needs Lst1 as listbox name Put code ...