Try something like
On Error Resume Next
' your code that may cause an error
If Err.Number = 91 Then
MsgBox "Invalid Name"
Exit Sub
End If
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
wrote in message
oups.com...
Hi All,
I am working in excel VBA. I have a userform with a combo box.
I have a
list of names in a worksheet.
I need a textbox to populate the employee code with respect to
the name
in the combo box.
To achieve this I have used 'find' function to find the name on
combobox_change event which finds the name and shows up the
corresponding employee code.
This works fine till the user selects from the dropdown.
However, if i
am trying to type in a name which does not exist on the sheet,
it gives
me Run-time error " 91 - Object Variable or with block variable
not
set" which is correct.
I want to capture this event and inform the user that this name
does
not exist in the spreadsheet.
Can someone please help me to do this. Thanks in advance.
Yash