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