Better VBA 7 - Code formatting tools

Proper formatting of the VBA source code is a crucial factor for the readability of the code. While you are writing code, you should format it correctly right away because it will help you to write solid, error free code. But what about maintaining legacy applications with badly formatted code? Of course, fixing the formatting of the code has massive benefits through improved readability, but reformatting the code manually takes a lot of effort in a big application. In this video I show two tools that reduce the effort to reformat VBA source code to virtually zero. Smart Indenter is a free add-in with the single purpose of indenting VB/VBA source code. Further info and download: http://oaltd.co.uk/Indenter/ MZ-Tools, an add-in containing a whole suite of useful extensions to Visual Studio and the VBA development environment, has a feature to properly indent source code. Further info and free trial version: https://mztools.com/ And there is another code indenting tool I discovered only after recording the video. AET VBE Tools - its for Excel VBA only, though. http://dailydoseofexcel.com/archives/2017/02/11/aet-vbe-tools/ More info on the Better VBA video series: http://codekabinett.com/rdumps.php?Lang=2&targetDoc=better-vba-code Here is another video about important elements of good code formatting and the difference between good and poorly formatted code: https://www.youtube.com/watch?v=rqoj1mQrbBs If you like this video, please share, like, and subscribe to this channel!