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

Please Login or Register  to view this content.

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