I'd like to limit limit the choices in an Excel combobox to the two items in the list.

I can specify exact match, but users can still enter text and get an error. What I'd like would be the equivalent to the limit to list proprty in Access.

I'll settle for some sort of error handler. I think it was error 380. When I try to put an error handler on the before or after update property nothing happes.

I notice that the error message is labeled form so maybe it is a form error, but, I don't see a form error event.

Thanks for any help