VBA editor colors -- strings?

[John Uebersax]

Is there a way to make text strings appear in a given color in the VBA
editor?

For example, in the line:

sFile = "C:/data.txt"

I'd like C:/data.text to appear in red.

Using VBA menu commands: Tools / Options / Editor Format

one can assign foreground/background colors to various elements -- but
I don't see literal text strings like this among them.

Thanks in advance for any suggestions.

John Uebersax

 

[Cindy M.]

Hi John,

Is there a way to make text strings appear in a given color in the VBA
editor?

No, sorry.

Working in a more "modern" IDE does spoil one...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail

 

[John Uebersax]

Hi Cindy,

Working in a more "modern" IDE ...

Thanks for the helpful clue.

I got the idea of color-coding text strings by looking at someone
else's VBA code. Now I think they probably prepared that code using a
customizable program editor, and not the VBA editor

John Uebersax
Brussels
satyagraha.wordpress.com