Components 186

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

Reads content of webpage with optional post data two main differences from

Card image
Listbox 1st item [Any]

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

Card image
SettingNameAlreadyFound

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

Card image
LastRow_Remove

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

Card image
FoundinList

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

Card image
RemoveDuplicates

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

Card image
iframeBtn

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

Card image
ListBox_SelectionCount

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

Card image
Old cell value

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

Card image
RowList_Matching

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

Card image
GetColumnIndex

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

Card image
CleanArray

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

Card image
merge2Arrays

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

Card image
tag_add

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

Card image
setSelectedIndex byname and byval

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

Card image
ExitTool and DoNothing

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