Run-time Error '91 ' ActiveX combobox

Hi.

I have an ActiveX combobox, which takes data from a spreadsheet, in column 'E' and 'F'


By typing a name NOT on my existing range, generates an error

Run-time Error '91 ':
The object variable or block variable 'With' is not defined

how can I create a trap for this error?
Thank you!

Cross-Post
http://www.mrexcel.com/forum/excel-q...-combobox.html

The trick in not to trap the error, but to avoid it to begin with. Show us the code.

But to answer your requestion.

Define a label. Point the error handler to that label. Code to correct.

Please Login or Register  to view this content.

Hi..
This is code

Please Login or Register  to view this content.

You probably need to test for F.Cells.Find(CB).Row before using it to populate Textbox1.

Please Login or Register  to view this content.

I tried to adapt but it did not work!

see my file and help me please, thank you!

The code runs as written. No error. :P

Try to save the file as a different filename and see if that fixes it. (I'm grabbing at straws here.)

Hi.

if you type a name that does not exist in the combobox, the error occurred!

Att

Try this.

Please Login or Register  to view this content.

Hi.

Was great!!!

thank you!!
it's solved!!