Improve VBA IDE: Highlight start and end of Blocks e.g. If/End If, With/End With, Do/Loop etc

It would be great if the VBA IDE would highlight...

(a) The start and of Blocks such as If/End If. So if you highlighted the "If" the matching "End If" would also be highlighted. This would be great for both coding but also auditing inherited code.

(b) Highlight incomplete Blocks: so if you start "If" it's red until such time the closing "End If" is added

143 votes

Greg shared this idea · Feb 19, 2018 · Flag idea as inappropriate… · Admin →

Under review · Oct 9, 2019

Show previous admin responses (2)

7 comments

An error occurred while saving the comment

Anonymous commented · July 26, 2018 3:17 PM · Flag as inappropriate

Go a step further and highlight end brackets to make nested code easier to debug.

Submitting...
Francesco commented · July 25, 2018 1:41 PM · Flag as inappropriate

Would be quite nice. Pushing it a bit further, code folding would be nirvana.

Submitting...
Ozair Khalid commented · July 23, 2018 11:56 PM · Flag as inappropriate

Great idea!

Submitting...
CW commented · April 11, 2018 1:57 PM · Flag as inappropriate

Yes, this would help so much with code review and debugging.

Submitting...
Anonymous commented · April 9, 2018 3:32 AM · Flag as inappropriate

Great idea! Very useful, especially for multiple nested statements.

Submitting...
Erika commented · April 9, 2018 3:16 AM · Flag as inappropriate

This would be such a time saver when working with nested blocks. I have to resort to 3rd party software sometimes, just to make sure everything matches up.

Submitting...
Juan Soto, Access MVP commented · March 2, 2018 10:46 AM · Flag as inappropriate

Wonderful idea Greg!

Submitting...