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

Card image cap
Listbox 1st item [Any]

Allow user to select [Any] as first item in list that will deselect all other ...

Card image cap
SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

Card image cap
LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

Card image cap
FoundinList

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

Card image cap
RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

Card image cap
iframeBtn

A button in iframe, to run certain command and return status to end user ...

iFrameBtn.zip

Card image cap
ListBox_SelectionCount

Counts how many items selected in a listbox (multi-selection listbox). Works ...

Card image cap
Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

Card image cap
RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

Card image cap
GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

Card image cap
CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

Card image cap
merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...