Populate userform label from cell

[tbuilt77]

I have a vlookup cell in a spread sheet. I want a userform label to display the value from the vlookup in a note on the userform. I can't figure out how to link a cell reference to a userform label. Any suggestions?

The label on the userform would say "The primary production line for this product is ??VLOOKUPVALUE?? Which production line would you like to schedule?"

The user then selects either the primary production line or another production line from a combo box drop down list.

 

[My Aswer Is This]

If your a new user of vba I would always leave my controls named as the default name.

A Userform default name is always UserForm1

Unless you have more then one userform in the same workbook.

And I would do the same for all my controls until I really have a grasp of vba

Giving your userform a name like this just makes things complicated

You said:

My user form is named UFFactoryComboBox

Why would you ever name your userform like this?

Sort of like never give your Textbox a name like Sheet14

And this originally was a very simple question.

That's why it's always best from the start to give specific details.

Like you never gave us the name of the sheet with your Vlookup results or the Range

If these things are not on the active sheet you must always give specific sheet names

​