View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Wilson John Wilson is offline
external usenet poster
 
Posts: 550
Default 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