How can I have my userform label pull from a specific range based on a variable?

[billyshears]

I created a userform to bring up. I can bring up the userform by pressing button 1 or button 2.

If I press button 1, I want the userform label to read as the input from Cell A1 on the work sheet. If I press button 2, i want the label to read as the data input from Cell B1

I know how to code the userform to grab the label from a specific cell, but I cannot figure out how to make it variable based on what button I am pressing

 

[dmt32]

Hi,
I assume you mean a button you are pressing on worksheet to display the UserForm? if so try

Sub Button1_Click()
    With UserForm1
        .Label1.Caption = Range("A1").Text
        .Show
     End With
End Sub

Sub Button2_Click()
    With UserForm1
        .Label1.Caption = Range("B1").Text
        .Show
     End With
End Sub

Adjust code as required to meet your project need.

Dave

 

[billyshears]

Yes, thanks. Where do I input that? by double clicking the label on the username form, or on the buttons?

 

[dmt32]

Yes, thanks. Where do I input that? by double clicking the label on the username form, or on the buttons?

Its the Button code if they are located on a worksheet - you place it either in your worksheet if using ActiveX buttons or in standard module if as in my example, using Form buttons
Code may need to be amended to meet your Userform & Label names if different.

Dave

 

[dmt32]

___

 

[billyshears]

I figured it out, thanks again