Loop to change command buttons

[stoney1977]

hello,

I have a userform with 300 Command buttons on and would like to setup a loop to change the captions and colours of the buttons.

The buttons are all name A1 to A300

set the command button name so a loop and move it on 1 number each time

Thanks

[romperstomper]

What do you want to change the captions and colours to?

[stoney1977]

What do you want to change the captions and colours to?

the camption would be to another string and the colour would be gray or red

Thanks

[romperstomper]

You basically need a loop like:

Please Login or Register  to view this content.