Codes Required
ListBox_SelectionCount
Counts how many items selected in a listbox (multi-selection listbox). Works ...
2022Apr21
ANC Bootstrap controls (Testing < and & # 6 0 ;)
Testing step in site (or in each HTML output function to replace < with < ...
2021Jun9
ListBox_Excel_Sort
Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...
2020Sep21
ANBS Controls Set3
3rd set of ANBS controls, Get Set1 here and
2019Dec5
ANBS controls
Set of functions to generate Bootstrap controls as strings. Controls available ...
2018Jun24
ListBox_SelectedIndexes
Create list of selected items in MSForms listbox as string separated by | Or ...
2018Jun11
Similar codes
ListBox_SelectionCount
Counts how many items selected in a listbox (multi-selection listbox). Works ...
2022Apr21
ListBox bug with TabIndex
Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...
Apr15
Frm6 - ANmaMultiSelect
Give users ability to multi-select from list of items into cells with separator. ...
2021Jun23
Listbox 1st item [Any]
Allow user to select [Any] as first item in list that will deselect all other ...
2022Nov13
Column2AnString_Unique
Creates list of unique items found in a column, returns string with items ...
2020May6
MoveDown + MoveUp
Moves an item in listbox up or down Needs Lst1 as listbox name Put code ...
2018Jun2
Recently by developer
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Random Codes
PivotTable_ShowHideItems
Show or hide item (or items) in PivotTable for a certain field. Passing ...
Jan23
Paging with Alternating Colors
This script will take the results of a query and sets up number of records per ...
2018Apr18