Components 188

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

Sorted from new to old.

SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

Sun 4AM

Match3_3rdNot0

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

Sat 5AM

ANmAddress_Value

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

Thu 11AM

CountColumnCells_Unique

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

Oct6

Choose20

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

Sep5

Choose10

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

Sep3

Choose2

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

Aug20

ANmAdd_ThenSort_2Columns

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

Jun1

ListBox bug with TabIndex

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

Apr15

SwitchTextinCells

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

Feb23

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

1 2 ...11 12