Positioning multiple command buttons on a userform using VBA

Hi

I have been searching the web for days for my answer!

I have 10 command buttons, cmd1, cmd2, cmd3 etc on a user form. These are positioned one below the other. When I click any of these buttons, say cmd3, then I want cmd3 to be placed at the top and another set of command buttons are placed below this one in a verticle placement. So in example, with cmd3 first then below it are a series of new buttons, cmd3_1, cmd3_2 etc.

I think an array is the answer but I can't fathom how to do it using vba.

Can anyone in this forum help?

Thanks

I knew this forum would come good! Thanks for taking the time Harry. This will get me what I need to do.

As I have many buttons, and the .Top property will vary by 40 each time (i.e. cmd1.Top=100, cmd2.Top=140, cmd3.Top=180 etc), I assumed that an array would have been required for these values.

Your code is a much neater way. It's shown me a new coding terminology.

Cheers