Thread: VBA Code Colors
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
PBezucha PBezucha is offline
external usenet poster
 
Posts: 120
Default VBA Code Colors

Another, trivial way is to convert the code, module by module, into the text
file, where it can be deliberately colored. It may be also a proper backup,
because it is again retransportable by parts back in the modules.
--
Petr Bezucha


"Gary Keramidas" wrote:

this isn't a free solution, maybe something like this would help. you could
print to a pdf and use it for a reference


http://www.starprint2000.com/product_vbacodeprint.aspx


http://submain.com/?nav=products.pcp

Color Schemes a.. Quick way to switch the colors for syntax highlighting,
you can choose predefined
b.. Default scheme for color printer
c.. Scheme for B&W printer
d.. Standard VB IDE colors
e.. You can even import your current color scheme from VB IDE


--


Gary


"JT" wrote in message
...
Is there a way to change the color of a couple of lines of code. Each year I
have to search through a lot of code to modify specific lines. I was
wondering if there is a way to change s line or two of code to a different
color (say red), so next year I can scroll through the code and look for the
red lines?

I've looked at the options in the VB Editor but couldn't find a way to
change a line and keep it that color when I re-open the Editor.

Thanks for the help.....Mike
--
JT