| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color constants in VBA
Mark,
From: Color Constants in Excel VBA help... Constant Value vbBlack 0x0 vbRed 0xFF vbGreen 0xFF00 vbYellow 0xFFFF vbBlue 0xFF0000 vbMagenta 0xFF00FF vbCyan 0xFFFF00 vbWhite 0xFFFFFF Regards, Jim Cone San Francisco, CA "Mark Tangard" wrote in message ... 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 | |
|
|
Similar Threads
|
||||
| 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) | |||
Threaded Mode
