Search results 68

Sorted from new to old.

ANStrVLookup

behaves as vlookup to return item from 2-dim ANStr Can choose which column, ...

Jun14

ANStrSort2

Sorting items inside ANStr, this one in ASP Classic (VBScript) Like the VBA ...

May25

ANmaDropdown Search

Shows drop down menu of matching items when user searches in textbox with ...

May13

ANmaNotMatch

Finds first item from RngAddr that is not listed in InRngAddr Returns the item ...

Apr19

FirstDuplicatedItem

Returns the value of first duplicated item found in a range. This is to ...

Apr18

ANString_to_ListSelects

Selects items in listbox from ANStringList. Assuming listbox is multi-select ...

Mar24

ListItemText_to_ListIndex

Finds the index of an item in listbox (or combobox) It searches for that item ...

Mar24

ANStrFind_AndOrRemove

Checks (and/or removes) if an item was found in list of items and return 1 if ...

Jan12

CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

2024Oct24

CountColumnCells_Unique

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

2024Oct6

ANmaSearch_OrFriends

Search for one of items in SearchFor_ListOfFriends inside SearchIn and return ...

2024Jul30

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

2024Apr29

ListBox bug with TabIndex

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

2024Apr15

MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

2024Apr8

ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

2024Feb20

Win10 ThisPC Virtual locations

I hate it when Windows forcing us to have additional items in "This PC" So, I ...

2024Feb5

1 2 3 4 5