Programmatically format VBA buttons

[snb]

Just to add:

If you put this in the userform's codemodule you can use:

sub snb()
  For j = 1 To 2
    Me("CommandButton" &j).backcolor = 12648447
  Next
end sub

it's the shorthand for

sub snb_longer()
  For j = 1 To 2
    controls("CommandButton" &j).backcolor = 12648447
  Next
end sub

or

sub snb_still_longer()
  For j = 1 To 2
    Me.controls("CommandButton" &j).backcolor = 12648447
  Next
end sub