Moves an item in listbox up or down Needs Lst1 as listbox name Put code ...
2018Jun2
Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...
Apr15
Counts how many items selected in a listbox (multi-selection listbox). Works ...
2022Apr21
Copy row height from row to another Used to fix row heights or merged cells to ...
2019Aug1
Calculates the area of objects. Pass formula argument as string and values as ...
2018Jul24
Adjust iframe height to its content after loading page Needed this trick in ...
Apr29
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
Number of Business days between two dates. Note that it doesn't take Christmas, ...
Oct25
Selects a shape inside sheet to change it, or if not found, it will create it ...
2022Jul21