Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Array Constants | Excel Worksheet Functions | |||
Constants in Excel | Excel Discussion (Misc queries) | |||
How to get a dump of Fill Color & Font VBA Constants? | Excel Discussion (Misc queries) | |||
vba constants for excel | Excel Discussion (Misc queries) | |||
constants | Excel Discussion (Misc queries) |