3 different command buttons on worksheet to call userform but to change label as well.

[danbates]

Hi,

I have 3 separate command buttons on my worksheet and I would like to call the same userform but I would like the label1 in the userform to have different title when it opens.

My command buttons are CommandButtonB, CommandButtonG, CommandButtonR and the userform is UserForm2.

Any help would be appreciated.

Thanks
Dan

 

[fadee2]

use the following under each of your command buttons

UserForm1.Caption = "Command Button R"
UserForm1.Show

 

[My Aswer Is This]

Try something like this:
Make three buttons and put this script in the button.
Change the name in each script to what you want for the Label

Sub Show_Me()
'Modified  12/15/2020  2:10:30 AM  EST
Userform1.Label1.Caption = "Jane"
Userform1.Show Modeless
End Sub

 

[danbates]

Thank you to both of you. Just what I was after.

 

[My Aswer Is This]

Thank you to both of you. Just what I was after.

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

 

[fadee2]

you are welcome....