I have a userform in my spreadsheet <frmEntry which includes a combo box
<cmb.Machine and a label <lbl.Desc.

The combo box is populated with values from column 'A' in another sheet
<Part Numbers during the userform initialization event.

I would like to code the <lbl.Desc caption by using a VLOOKUP of the
selected value in the combo box to look up the appropriate value in sheet
<Part Numbers column 'B'

The following code is giving a COMPILE ERROR, can anyone help me out here?

frmentry.lblDesc.Caption=worksheetfunction.vlookup (frmentry.cmbMachine.Value,'PartNumbers'!C1:C2,2,f alse)

DS