Give users ability to multi-select from list of items into cells with separator. ...
2021Jun23
Show list of items with their description from "Settings" sheet Have that list ...
2018May17
Dropdown list for input box works as Autocomplete Multi-column, themeable ...
2019Jun25
Read list of items from Settings sheet, then Sort, then save, before reading ...
2022Aug31
Allow only Currency into textbox, text box will allow only nnnn.nn where n=1 ...
2018Jun27
Listbox in Excel sometimes have issue adjusting height to items added inside, ...
2018Aug25
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
Swap two numbers variables without using third variable A trick worth saving ...
2022Oct17
Finds last occurrence of a match in a column Finds the row of last time an ...
2019Jun12
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1