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
|