Hi Jake and Chip,

I tried option two. It works. Thanks a ton...

Chip Pearson wrote:
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