Components 191

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

Sorted from new to old.

ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

Sun 7AM

Match5_5thNot0 and Match6_6thNot0

Searches for 4 cells in 4 columns then checks for 5th column to not equal zero ...

Nov13

ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

Nov8

SettingRead_Bulk

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

Nov3

Match3_3rdNot0

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

Nov2

ANmAddress_Value

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

Oct31

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

1 2 ...11 12