Esopera
01-18-2018, 12:39 PM
I'm getting an error with the following code. I would like to use the combobox to vlookup data on a sheet, then hit a submit button to change the information. Right now I'm getting an error just running a vlookup from the combobox.
Private Sub LNameCombobox_Change()
If Me.LNAMEComboBox.Value = "" Then Exit Sub
PNTextBox.Value = Application.VLookup(Me.LNAMEComboBox.Value, Range("Sheet1!$B2:T10000"), 3, 0)
End Sub
The error is in line 3.
Any help would be greatly appreciated.
Private Sub LNameCombobox_Change()
If Me.LNAMEComboBox.Value = "" Then Exit Sub
PNTextBox.Value = Application.VLookup(Me.LNAMEComboBox.Value, Range("Sheet1!$B2:T10000"), 3, 0)
End Sub
The error is in line 3.
Any help would be greatly appreciated.