Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Change Syntax
Greetings,
I have a CommandButton on a worksheet from the ToolbarsControl Toolbox. I need it to change colors when I click on it. Using the macro recorder, the button shows up as a Shape. However the recorder did not record the actual color changing that I hopped it would. The recorder showed this: ActiveSheet.Shapes("CommandButton1").Select From that I tried this: With ActiveSheet.Shapes("CommandButton1") .Select With .Fill .BackColor = &HFFFF00 .ForeColor = &H0& End With End With This give a type mismatch error high lighting the .BackColor line. Anyone know how to make this work? Any help is appreciated. -Minitman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Correct Syntax for Changing Color of Cell Based on Value | Excel Discussion (Misc queries) | |||
Syntax-Change? | Excel Programming | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
Syntax for changing font color in a Shapes object | Excel Programming | |||
Font.Color - syntax error ? | Excel Programming |