These are some limits I found during my work in Excel-VBA For more of Excel ...
2020Feb5
This will limit the number of characters a user types in a textarea.
2018Apr18
Show number of characters in a textarea and limit if it goes greater than ...
2018Jul5
Reads last some characters of a file, needs to see contents of large files that ...
2023Apr20
Finds location of 1st numeric character inside string starting from a certain ...
Feb25
A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...
2022Oct12
Reads certain chunk of a file in binary. Used with large files (like ~7gb ...
2023Apr28
Removes duplicated items from a 1-dim array into new array, does not modify ...
2022Jul7
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
Execute any command in Excel VBE, using Application.Evaluate to execute almost ...
2020Feb16
Checks if URL is actually working. Uses XMLHTTP object to see if that URL ...
2018Dec9
Saves/Reads selected theme into file. Used with Bootstrap 3 in most of my ...
2018Jul29
Using Classic ASP and cookies, allow users to personally choose between normal ...
2018Jun10