Thread: ColorConstants
View Single Post
  #1   Report Post  
Bill Martin
 
Posts: n/a
Default ColorConstants

Searching through the Excel97 VBA Help system for something else, I came across
the entry for ColorConstants. It says:

The ColorConstants module contains predefined color constants.
These constants can be used anywhere in your code.

This sounds useful to me, but where in heck does one find the "ColorConstants
module"? It doesn't seem to automatically appear anywhere and doing a search of
my entire disk for some file of that name returns nothing. Also searching the
Microsoft website for "Colorconstants" returns nothing.

I have stumbled into the fact that I can use ColorConstants.vbMagenta for
example to set a color, but the drop down list only shows 8 "vb" colors.

Bill