Search results 83

Sorted from new to old.

ANStrVLookupAll

Retuns list of all matchings after doing vlookups to return item from 2-dim ...

Jun14

ANStrVLookup

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

Jun14

DBTableCol_Array

Reads 1 column from SQL DB table and return as 1-dimension array oConn object ...

May30

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

ListBox_Read and ListBox_Save

Reads or saves to a certain column in multi-column listbox in VBA Userform Can ...

Mar11

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

1 2 ...5 6