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
Install/Uninstall SQLNativeClient DB driver
Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...
Feb8
RunFromTemp
Check if an Excel file is running from 'Temp' location or regular folder This ...
2018Jun17