Friday, June 20, 2014 – Permalink –
Realign a bunch
Indenting blocks of VBA code, such as statements within loops or If...Then statements, makes reading a procedure much easier.
You probably indent a code statement using the [Tab] key, and outdent by using [Shift][Tab].
However, you may not be aware that the [Tab] and [Shift][Tab] techniques also work when multiple code lines are selected.
The Visual Basic Editor also provides Indent and Outdent buttons on the Edit toolbar that allow you to easily reposition blocks of code.
See all Topics excel
<Doug Klippert@ 3:25 AM
Comments: Post a Comment