Code to Make a Lot of Command Buttons On a Userform and name them

[vbasupernoob]

I'm trying to use command buttons as pixels on a user form.

I need to create a user form containing 51x51 (a square 51 command buttons in length, 51 in height) filled with command buttons 7 in length and 7 in height.

Also it needs to name them based on their position as if they're arranged in an on an x-y graph where the 26th command button in the 26th row is Cmd00 and then they go out from that to Cmd2525 in the top right cnr and Cmd-25-25 in the bottom right corner.

I have no idea how to do this programatically and I'm not particularly keen on doing it manually.

Thanks for your help in advanced

[hulpeloos]

Create a new userForm
double click on it
copy below code to it
go back to the userfomr and play it

let me know if this is what you want to go to (it looks small to me)

Please Login or Register  to view this content.

[vbasupernoob]

That's perfect! Only Problem is that I want to make it so it's on the userform design. Like it needs to be there when I'm designing the userform. How can I use that code in a macro?

[hulpeloos]

this is what i got so far , 11 command buttons but you can change it (see green comments)

Please Login or Register  to view this content.

[hulpeloos]

@ vbasupernoob
I still try to work out the names of the buttons with the X Y reference (the - is causing issues)

how important is this ?

where the 26th command button in the 26th row is Cmd00 and then
they go out from that to Cmd2525 in the top right cnr and Cmd-25-25 in the bottom right corner

This is what i could come up with , but taking it further then 26 it creates name duplicates.
i must be missing something but don't see it yet.

Run this one and let me know what you think about it.

Please Login or Register  to view this content.

[hulpeloos]

Just realised in older versions you might actualy need to insert a blank UserForm prior to running it a first time (unless you already have userform in your workbook.