Hi everyone,

First time I've joined and posted on an excel forum :D
As the title suggests I'm having issues programmatically formatting buttons, rather than;

Code:
userform1.CommandButton1.backcolor = 12648447
userform1.CommandButton2.backcolor = 12648447
I would like to do something like:

Code:
For x = 1 To 2
        userform1.CommandButton & x.backcolor = 12648447
Next
Any suggestions?