Assign Click Action to Dynamic Button on Userform

I have a code that will populate a Userform with buttons and caption them based on a list of names in a worksheet:

Excel.PNG

Essentially what I'm trying to make happen is that when this Userform loads, the user can click any of the buttons and it will save the caption of the selected button to a global string variable 'BtnCaption', hide Userform1 and show Userform2. I've tried to look up how to do this but everything I found didn't really make sense or didn't work with what I'm doing.

Here's my code in Userform1 for creating the button if that helps:

Please Login or Register  to view this content.

.
Is this what you were attempting ?

Please Login or Register  to view this content.

Paste the above into the UserForm1 UserForm_Initialize macro.

Create three more userforms, #2, #3 & #4.

No, I've been able to do something like what you made. The thing is that my code from above will populate a Userform with buttons based on data in the rows from column A so if it's run with what I have from above it'll show the Userform with 3 buttons, but for example if I run it again after adding 'DDD' to the button names it will create a Userform like this:

Excel2.PNG

So I can't just write code for 3 command button clicks because I don't know how many buttons will be on the Userform. Also, I want Userform2 to load no matter which option is picked because it's going to ask the same question next, I just need the option from Userform1 to be stored as a variable somehow and I'm trying to make it work with buttons rather than a Listbox.

Here's my excel file in case that helps:

Dynamic Button Test.xlsm

.
My apologies .. this is not something I can get my head around. Hopefully another Forum Member will be able to assist.

No worries, thanks anyway!

Thanks bakerman2! This is exactly what I needed, I figured it might involve a class module but I don't have much experience using them.