Components 185

Controls, objects and classes, also cells, sheets, workbooks in VBA-Excel
Sorted from new to old.
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. ...

Card image
Windows Common Controls 6.0

This is the needed library to have Windows Common Controls installed to be used ...

Card image
NavigatePost

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