Insert a number into specific cell depending on selected label

Good afternoon folk

I have a Userform with 10 labels,,,, is there a way when a label is selected the relevant number is inserted into cell A2 in worksheet 2

e.g,,, if the third label is selected,, the number 3 is inserted

if the 8th label is selected the number 8 is inserted

etc



many thanks

JT

Here is one way to do it. Place the following code in the UserForm that has the labels...

Please Login or Register  to view this content.

This is just for the 1st 2 labels. You would have to do this for each label.

You're welcome, glad it worked for you. Thank you for the rep