Here's our Microsoft Office Tip for.. September 14, 2004
Click Here to see a complete list of all of our previously released Tips!
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.