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

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

Card image cap
tag_add

Add to textbox from listbox (select option) ensure its uniqueness

Card image cap
setSelectedIndex byname and byval

Set active (Selected) item in listbox using javascript Imported and modified ...

Card image cap
ExitTool and DoNothing

My way of Exiting tool in case or error, also another sub that basically does ...