copy command bouton

With standard tools:

1) select a button, and copy
2) paste it as many times as you need placing roughly where you want them
3) select all, right click and from popup menu select left alignment. So you have horizontal placement ready
4) look at properties (if not visible open properties window by pressing F4), namely on "Top"

The top is a number (in pixels, which is a location of topleft button corner in userform. You can change these properties to form regular arithmetic progression.

For example - you have 10 buttons. First have top at 5, last at 185 then the distance between corners of each 2 neighbours shall be 20
(185-5)/(10-1) =20
and property top shall be set for
Button1: 5
Button2: 25
Button3: 45 and so on.

Place this code in a blank userform and experiment with it.

Please Login or Register  to view this content.

I doubt that will happen, you probably need to add the buttons and edit them to do what you want.

I just said it can't be done, you need to add the button and edit it so it does what you want to do. Or just copy and paste it manually as explained in post#2