Thank you for your responses but I am still unable to get it to work correctly. The problem is definitely on my side. I am not a programmer.

mdmackillop, I was unable to get anything to display in the combo box.

offthelip, Your suggestion worked the first time I selected something. But, if I selected anything else the nomenclature label would not change. It was also overwriting the vlookup formula in B23.

SamT, The vlookup formula is in cell B23. But I used the rest of your code and nothing happened:
Private Sub PartNumberComboBox_Change()
NomenclatureLabel.Caption = Range ("B23").Value
End Sub

So, I tried a few different things. When I changed “Change” to “Click” the nomenclate would be displayed and would change when I clicked on the label. Close, but I need it to change automatically. When I changed “Change” to “Activate” nothing happened.
I am sorry to keep bothering you but thank you in advance for all of your help.