Search results 86

Sorted from new to old.

ANmArray_1stMatch_orPartial

Returns the 1st item found in array matching partially the search for value. ...

Aug14

ListBox redraw bug (fm20)

Fix to the bug that when changing item in listbox that is not visible because ...

Aug2

DuplicatedList

Returns list of duplicated items in a range as ... ' ...

Jun21

ANStrVLookupAll

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

2025Jun14

ANStrVLookup

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

2025Jun14

DBTableCol_Array

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

2025May30

ANStrSort2

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

2025May25

ANmaDropdown Search

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

2025May13

ANmaNotMatch

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

2025Apr19

FirstDuplicatedItem

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

2025Apr18

ANString_to_ListSelects

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

2025Mar24

ListItemText_to_ListIndex

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

2025Mar24

ListBox_Read and ListBox_Save

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

2025Mar11

ANStrFind_AndOrRemove

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

2025Jan12

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

1 2 ...5 6