Hello, I'm trying to get the data in cell B23 to be displayed in my userform. B23 will change depending on what information is selected from combo "PartNumberComboBox" through vlookup. I want the value for B23 displayed as soon as a selection is made from the combo box. The user can make several selections from the combo box so the B23 will change a lot. I would prefer to display B23 as a Label, but a text box will work just as well. Here is the code I have but it doesn't work:

Private Sub NomenclatureLabel_Activate ()
NomenclatureLabel.Caption = Range ("B23").Value
End Sub
Thank you in advance.