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

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

Card image cap
CellSave and CellRead

Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...

Card image cap
Part of cells in Excel

How to modify part of text inside an Excel cell using VBA. Something in my ...