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

Card image cap
SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

Card image cap
CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

Card image cap
CellHyperlink_ToSheet

Will add hyperlink in a cell to a sheet in same workbook Not Hyperlink ...

Card image cap
LogSheet_Add + LogSheet_Clear

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...

Card image cap
RowsCount

Get total number of rows for a certain worksheet in certain workbook workbook ...

Card image cap
CanAccessVBA

Returns true if VBA is accessible through code, returns false if not

Card image cap
DirsCombo_Read

Read directories in a specified folder into a combobox Needs FrmBr having Cbo1

Card image cap
RunFromTemp

Check if an Excel file is running from 'Temp' location or regular folder This ...

Card image cap
CellCommentRead + Save

Reads/Saves a comment into a cell CellCommentRead to Reads comment from a ...

Card image cap
MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

Card image cap
CellRead

Reads a value giving column, row, sheet and workbook name Accepts D+R to ...

Card image cap
Match4

Matching 4 values at the same time in 4 columns Just like Match the function, ...