Similar codes
Excel-VBA Limits
These are some limits I found during my work in Excel-VBA For more of Excel ...
2020Feb5
Limit Characters in a TextArea
This will limit the number of characters a user types in a textarea.
2018Apr18
Limit Textarea
Show number of characters in a textarea and limit if it goes greater than ...
2018Jul5
ReadLastChars
Reads last some characters of a file, needs to see contents of large files that ...
2023Apr20
VBInstr_Numeric
Finds location of 1st numeric character inside string starting from a certain ...
Feb25
Dropdown button commands
A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...
2022Oct12
ReadBinaryChunk
Reads certain chunk of a file in binary. Used with large files (like ~7gb ...
2023Apr28
RemoveDuplicates
Removes duplicated items from a 1-dim array into new array, does not modify ...
2022Jul7
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
Random Codes
FontAwesome icons in Office apps
Best way to use FontAwesome set of icons in apps, mainly my Excel tools and ...
2023Jan31
Frm6 - ANmaMultiSelect
Give users ability to multi-select from list of items into cells with separator. ...
2021Jun23
Vertical page breaks
Change Vertical page breaks in Excel spreadsheet preparing to print Looks like ...
2021Feb24
Paging with Alternating Colors
This script will take the results of a query and sets up number of records per ...
2018Apr18