View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Tangard[_3_] Mark Tangard[_3_] is offline
external usenet poster
 
Posts: 18
Default Color constants in VBA

Are there no color constants in Excel VBA for fonts, interior shading,
etc., other than the usual None and Auto? I don't see a list in the
Help, and I've tried all the usual xl- and vb- prefixed combinations
(separating prefix from color name with Color, ColorIndex, or nothing).
Does Excel not have the semi-English constants like these in Word:

Selection.Font.Color = wdColorDarkBlue
Selection.Font.ColorIndex = wdDarkBlue
Selection.Cells(1).Shading.BackgroundPatternColor = wdColorDarkBlue
Selection.Cells(1).Shading.BackgroundPatternColorI ndex = wdDarkBlue

I was sure I'd seen them someplace but noooooo.....?

TIA
--
Mark Tangard, Microsoft Word MVP
"Life is nothing if you're not obsessed." --John Waters