Afternoon all,
I'm trying to pull a value from an adjacent cell within a table/range into a text box in a userform when the user selects an item from the combo box. See below code which I'm using that is returning a runtime error
Private Sub cmbProd_Change()
txtProd.Value = Application.VLookup(Me.cmbProd.Value, Sheets("Lookups").Range("C2:H17"), 2, 0)
End Sub
Any ideas as to what I could be doing wrong?
Thanks in advance
I'm trying to pull a value from an adjacent cell within a table/range into a text box in a userform when the user selects an item from the combo box. See below code which I'm using that is returning a runtime error
Private Sub cmbProd_Change()
txtProd.Value = Application.VLookup(Me.cmbProd.Value, Sheets("Lookups").Range("C2:H17"), 2, 0)
End Sub
Any ideas as to what I could be doing wrong?
Thanks in advance