Here's our Microsoft Office Tip for.. September 14, 2004
Click Here to see a complete list of all of our previously released Tips!
Color Constants
Referring to colors in your code can be a bit of a nuisance because you must remember the color's corresponding integer. If you're working with the Windows standard colors, your work is made easier by a few intrinsic constants. Instead of looking up a color integer, you can simply use one of these constants:

  • Black vbBlack
  • White vbWhite
  • Red vbRed
  • Yellow vbYellow
  • Blue vbBlue
  • Green vbGreen
  • Cyan vbCyan

Working with these constants should prove much easier and more efficient than using the color's integer values.