Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Back color of dynamically-created buttons
Hi,
I have created a number of buttons using code which works very successfully. The code I've used is as follows: 'In progress With ActiveSheet.Buttons.Add(Left:=l, Top:=t + 20, Width:=60, Height:=16) .OnAction = "Pro_Hilite" .Characters.Text = "In Progress" .Name = "cmdProg" End With (In progress is the name of one of my buttons.) If I add in the statement .BackColor = RGB(0, 255, 0),or .BackColor = vbRed to this code, then I get an error message saying the object doesn't support this property or method. My question is: can I change the back color of a button created this way and if so how could I do it? Many thanks in anticiaption. Simon |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Back color of dynamically-created buttons
Hi Simon,
You can't change the Backcolor of Buttons from the Forms menu, manually or programmatically. You can change Backcolor of Buttons from the Control's toolbox (view code and properties - F4), but you can run into other problems when adding these and their code at runtime. Regards, Peter T "simon" wrote in message om... Hi, I have created a number of buttons using code which works very successfully. The code I've used is as follows: 'In progress With ActiveSheet.Buttons.Add(Left:=l, Top:=t + 20, Width:=60, Height:=16) .OnAction = "Pro_Hilite" .Characters.Text = "In Progress" .Name = "cmdProg" End With (In progress is the name of one of my buttons.) If I add in the statement .BackColor = RGB(0, 255, 0),or .BackColor = vbRed to this code, then I get an error message saying the object doesn't support this property or method. My question is: can I change the back color of a button created this way and if so how could I do it? Many thanks in anticiaption. Simon |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Back color of dynamically-created buttons
Forgot to suggest - to simulate a coloured button look at AutoShapes Basic
Shapes and the one that looks like a double rectangle. Format line to "No Line" and colour as required. Add text and assign macro. Record a macro for ideas on how to code. Regards, Peter T "Peter T" <peter_t@discussions wrote in message ... Hi Simon, You can't change the Backcolor of Buttons from the Forms menu, manually or programmatically. You can change Backcolor of Buttons from the Control's toolbox (view code and properties - F4), but you can run into other problems when adding these and their code at runtime. Regards, Peter T "simon" wrote in message om... Hi, I have created a number of buttons using code which works very successfully. The code I've used is as follows: 'In progress With ActiveSheet.Buttons.Add(Left:=l, Top:=t + 20, Width:=60, Height:=16) .OnAction = "Pro_Hilite" .Characters.Text = "In Progress" .Name = "cmdProg" End With (In progress is the name of one of my buttons.) If I add in the statement .BackColor = RGB(0, 255, 0),or .BackColor = vbRed to this code, then I get an error message saying the object doesn't support this property or method. My question is: can I change the back color of a button created this way and if so how could I do it? Many thanks in anticiaption. Simon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scaling a chart that has been dynamically created in vb | Charts and Charting in Excel | |||
dynamically changing chart y axis using spin buttons and worksheet_calculate event | Excel Programming | |||
Assign macros to dynamically created form elements | Excel Programming | |||
Dynamically Adding Code to Buttons on an existing UserForm | Excel Programming |