Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button colour
I have a button on a userform. When a certain checkbox
is checked I want the button to appear black. I do this using the BackColour property and using 17 as the color number. When the checkbox is not checked I want to turn the colour of the button back to grey. I am using 15 for this. However, the button will not change to the colour denoted by 15 when I do this. That is, it stays at black (17) even if the chbkx = False. Why is this? Thanks If PrintColourMapChkBx = True Then CellComColBtn.BackColor = 17 End if If PrintColourMapChkBx = False Then CellComColBtn.BackColor = 15 End If |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
command button colour | Excel Discussion (Misc queries) | |||
Is it possible to change the blue colour of an activated Auto Filter button? | Excel Discussion (Misc queries) | |||
Macro button colour change??? | Excel Worksheet Functions | |||
command button colour | Excel Programming | |||
Colour Button | Excel Programming |