Improve VBA IDE: improved code coloring
I think the color coding of the Office VBA IDE could be improved to match, say, that of NoteBook++.
If you copy your VBA code into NoteBook++ (and select Language: Visual Basic) you'll see improved color coding compared to the current VBA IDE. For example:
(a)Line Numbers are red
(b)The colors are easier to see (more contrast) and customizable
(c) Characters between parentheses are red e.g. Me.lstContacts.Column(20) where the 20 is shown in red
(d) If you highlight text with the mouse, other occurences of the same text are highlighted on the page
(e) string characters between quotes are grey
Neil Ginsberg commented
I agree. And I would just add to this: ability to highlight a block of text and apply a color to it. Sometimes when working with nested IF statements that go on for a long time, it's hard to track what belongs to what. Ability to manually apply a color to a block of text would be helpful. Or perhaps just the ability to apply a color to everything between an IF and an End If, excepting nested If's between them.
I think this would be nice
This would be soooo helpful. Thanks for the comments about Notepad++. I didn't know that. I'm going to start using that now!
Jan Einar Ingier commented
Especially the (d) point is very nice in Notepad++, I use it a lot to quickly find use of variable names, keywords etc. This feature would be very nice inside the VBA ide...
Just a small comment: I think you mean "Notepad++"