Combo Box - Match Required help

[jhahes]

Could someone please help me with the following?

I have a user form

3rd field or tab down is a combo box field (cboPayable)

I have the properties for the cboPayable ( matchrequired set to true)
-all the selections are via rowsource from another sheet


Is there anyway that if the user enters something that doesn't match
can get a msg box to popup and ask them if they want to add that to th
accounts.

The problem i am having is i am trying to use the exit event in th
cboPayable. And when i exit or tab from that field( and the valu
doesn't match then) a microsoft message box appears that says invali
property use. then my msg box comes up. But not until i close al
forms. is there anywya to bypass this message from microsoft.

Thanks for any hel

 

[Guest]

http://www.cpearson.com/excel/download.htm

eventseq.xls

provides msgbox for every event as it happens

a great debugger for your question