Command Button Color For Next Loop
 

I can get this to work:
(using "x" as an integer variable)

activesheet.oleobjects("Commandbutton" & x).visible = true

but this doesn't:

activesheet.oleobjects("Commandbutton" & x).forecolor = vbRed

Any ideas on how to change the CommandButton color in a For/Next
loop with a variable?

Thanks,
John

Command Button Color For Next Loop
 

ActiveSheet.OLEObjects("Commandbutton" & x).Object.ForeColor = vbRed


--
HTH

Bob Phillips

"John Wilson" wrote in message
...
I can get this to work:
(using "x" as an integer variable)

activesheet.oleobjects("Commandbutton" & x).visible = true

but this doesn't:

activesheet.oleobjects("Commandbutton" & x).forecolor = vbRed

Any ideas on how to change the CommandButton color in a For/Next
loop with a variable?

Thanks,
John

Command Button Color For Next Loop
 

"Bob Phillips" wrote in message
...
ActiveSheet.OLEObjects("Commandbutton" & x).Object.ForeColor = vbRed


--
HTH

Bob Phillips

"John Wilson" wrote in message
...
I can get this to work:
(using "x" as an integer variable)

activesheet.oleobjects("Commandbutton" & x).visible = true

but this doesn't:

activesheet.oleobjects("Commandbutton" & x).forecolor = vbRed

Any ideas on how to change the CommandButton color in a For/Next
loop with a variable?

Thanks,
John

Command Button Color For Next Loop
 

Bob,

Sometimes it's the simplest things that trip you up.

Thanks for the help.

John

"Bob Phillips" wrote in message
...
ActiveSheet.OLEObjects("Commandbutton" & x).Object.ForeColor = vbRed


--
HTH

Bob Phillips

"John Wilson" wrote in message
...
I can get this to work:
(using "x" as an integer variable)

activesheet.oleobjects("Commandbutton" & x).visible = true

but this doesn't:

activesheet.oleobjects("Commandbutton" & x).forecolor = vbRed

Any ideas on how to change the CommandButton color in a For/Next
loop with a variable?

Thanks,
John