Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a routine that passes the back colour of a button
to the interior colour of a range called Comrng. The colour the button takes on is based on a routine. When the button is coloured(by routine), the routine works fine. However, when I have it set up using its default grey (&H8000000F&) colour, teh Comrng takes the valu of 0 and diplays a black interior color. When it is woking, the immediate window shows: ?CellComColBtn.BackColor 16764057 ?Comrng.Offset(-1, 0).Interior.Color 16764057 When its not it shows: ?CellComColBtn.BackColor -2147483633 ?Comrng.Offset(-1, 0).Interior.Color 0 What is going on here????? If ComChkBx = True Then Set Comrng = .Worksheets(AuditShtName).Range (PasteStartCell).Offset(0, ChkbxArray(0, 1) * 2 - 2) Comrng.Offset(-1, 0) = "Cell Comments" Comrng.Offset(-1, 0).Interior.Color = CellComColBtn.BackColor End If |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
No Interior Color Macro | Excel Discussion (Misc queries) | |||
Cell interior color | Excel Discussion (Misc queries) | |||
color the interior of a range | Excel Worksheet Functions | |||
Interior Cell color | Excel Programming |