Components 59

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

CanAccessVBA

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


DirsCombo_Read

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


RunFromTemp

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


CellCommentRead + Save

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


MatchIf_ThenDelete

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


CellRead

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


Match4

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


Match3

Matching three values at the same time in three columns Just like Match the ...


Match2

Matching by two values at the same time in two columns Just like Match the ...


HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...


MatchIf (aka VMatchIf)

The best Match I created, return 0 if not found, kind of CountIF+Match ...


WorkbookOpen_ANmar

Opens Workbook without running AutoMacros and without letting the user know ...