Components 201

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

Sorted from new to old.

CountColumnCells_Unique

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

2024Oct6

Choose20

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

2024Sep5

Choose10

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

2024Sep3

Choose2

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

2024Aug20

ANmAdd_ThenSort_2Columns

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

2024Jun1

ListBox bug with TabIndex

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

2024Apr15

SwitchTextinCells

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

2024Feb23

HMatchIf_Multi

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

2023Oct30

Arr_1Dim_2Str

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

2023Aug14

CopyDynamicRangeValue

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

2023Aug10

Range22DimArray

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

2023May11

ArrSort_5Arr and ArrSort_7Arr

2 functions to sort 5 Arrays or 7 Arrays respectively.

2023Apr23

ArrSort_4Arr

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

2023Apr14

EmailSend_Outlook

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

2023Apr5

Windows Common Controls 6.0

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

2023Feb19

NavigatePost

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

2023Jan14

1 2 ...12 13