Proper code formatting is essential to prevent errors and increase readability. AutoMacro has several VBA formatting tools available:
In the Misc. Utilities page you'll find two other tools that might also qualify as "formatting" tools:
The comment / uncomment feature allows you to quickly comment or uncomment multiple lines of code at once. The feature is smart enough to identify when some lines of code are commented and others are not, so if you have a block of partially commented code, you can quickly standardize the commenting.
Auto Indent adds proper code indentation to the active module.
Proper indentation makes your code easier to read and reduces the chances of errors.
By default the code indentation will indent all code one "tab" to start. This setting can be changed in the Settings Menu:
Via the buttons on the Code Tools toolbar:
and via the right-click menu:
Often when coding, blank lines can accumulate. The remove Excess Linebreaks tool scans your active code module and deletes blank lines whenever more than two consecutive blank lines are found.
Use this in conjunction with the Auto Indent tool to quickly clean up your code.
Via the buttons on the Code Tools toolbar:
and via the right-click menu:
Read more here
Read more here
Last modified 4 years ago.