Similar codes
MoveDown + MoveUp
Moves an item in listbox up or down Needs Lst1 as listbox name Put code ...
2018Jun2
ListBox bug with TabIndex
Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...
Apr15
ListBox_SelectionCount
Counts how many items selected in a listbox (multi-selection listbox). Works ...
2022Apr21
CopyRowHeight
Copy row height from row to another Used to fix row heights or merged cells to ...
2019Aug1
CalcArea
Calculates the area of objects. Pass formula argument as string and values as ...
2018Jul24
Dynamic iframe height
Adjust iframe height to its content after loading page Needed this trick in ...
Apr29
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
TeeOpen_ProtectTee + TeeOpen_UnprotectTee
Protect or unprotect a workbook (already open) remotely from another workbook ...
2019Jun2
SharePointURL2Path + Path2SharePointURL
Converts SharePoint URL to regular folder path and the other way, giving the ...
2018Jun30
FixPath, IsThere, IsThere1 ...
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
2018Jun11