Label Click Event

**molesy** · 02-16-2014, 10:08 AM

Can someone help with filling a textbox from a cell using a label click event. I have attached an example.

**buran** · 02-16-2014, 10:26 AM

hi, change your code for the click event like this

Private Sub Label1_Click()
    Load UserForm2
    UserForm2.TextBox1.Value = Range("A1").Value
    UserForm2.Show
End Sub

Of course there also other ways to do the same, e.g. use UserForm2 Initialize event...
I assume you have a reason to use label, instead of command button...

**molesy** · 02-16-2014, 10:35 AM

Thanks, i need to use labels as i have a userform that has labels and they are filled in with text to guide the user and depending on the choice of label it will populate the text from a cell into the textbox