Userform command button

[WAF875]

Is it possible to assign a variable number to command buttons I am using in a userform. If for example I say CommandButton1.BackColor = 255 I would like that to be CommandButton (Range("A1")).BackColor = 255 in which the command button number would be the value in cell A1. Thanks Hope someone can help

 

[RoryA]

You need the controls collection of the userform. If the code is in the form:

me.controls("Commandbutton" & range("A1").value).backcolor = 255

 

[WAF875]

You need the controls collection of the userform. If the code is in the form:

me.controls("Commandbutton" & range("A1").value).backcolor = 255

Thanks RoryA that worked fine, I was trying to do it outside the Private subs

 

[RoryA]

If the code is not in the userform, you'd use userformname.controls (or use the relevant variable holding your form instance if you're doing things "properly" )

 

[WAF875]

If the code is not in the userform, you'd use userformname.controls (or use the relevant variable holding your form instance if you're doing things "properly" )

Thanks again that would make things easier

 

[Peter_SSs]

Thanks RoryA that worked fine, I was trying to do it outside the Private subs

The marked solution has been changed accordingly.
In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.