Components 187

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

Searches for two cells in two columns then checks for 3rd column if not equal ...

Card image
ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

Card image
CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

Card image
Choose20

Chooses from 20 options based on the passed ID, can have any of these passed. ...

Card image
Choose10

Choosing a return value based on an ID. Since we have Choose2, Choose3 and ...

Card image
Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

Card image
ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

Card image
ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

Card image
SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

Card image
HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

Card image
Arr_1Dim_2Str

Converts 1-dimension array into text. Meet Join. A way to convert array into ...

Card image
CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

Card image
Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

Card image
ArrSort_5Arr and ArrSort_7Arr

2 functions to sort 5 Arrays or 7 Arrays respectively.

Card image
ArrSort_4Arr

Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...

Card image
EmailSend_Outlook

Send email using Outlook object with attachments With AI-generated post image. ...