Apply validation on two cells, when a 3rd cell is changed When modifying a ...
2020May27
Give users ability to multi-select from list of items into cells with separator. ...
2021Jun23
Creates list of unique items found in a column, returns string with items ...
2020May6
Shows or hides an item or items in a PivotTable filter field. Passing ...
Jan22
Show list of items with their description from "Settings" sheet Have that list ...
2018May17
Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...
2018Jun14
Allow users to select from list box based on search terms. Have a text box and ...
2018Jun7
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...
2018Apr14
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...
2023Mar14
Check is this VBA-Excel file is running from a shared folder (Starts with \\) ...
2018Aug9
Returns a random password that is easier to remember, such as BONES or LAMOT. ...
2018Jun11