Search results 108

Sorted from new to old.
Card image
ANStrVLookupAll

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

Card image
ANStrVLookup

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

Card image
DBTableCol_Array

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

Card image
ANStrSort2

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

Card image
ANmaDropdown Search

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

Card image
ANmaNotMatch

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

Card image
FirstDuplicatedItem

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

Card image
ANString_to_ListSelects

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

Card image
ListItemText_to_ListIndex

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

Card image
ListBox_Read and ListBox_Save

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

Card image
ANStrFind_AndOrRemove

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

Card image
CleanArray_2Dim

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

Card image
CountColumnCells_Unique

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

Card image
ANmaSearch_OrFriends

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

Card image
MatchIf2Up

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

Card image
ListBox bug with TabIndex

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