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 i can get a msg box to popup and ask them if they want to add that to the accounts.

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

Thanks for any help

[Vacation's Over]

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

eventseq.xls

provides msgbox for every event as it happens

a great debugger for your question



"jhahes" wrote:

>
> 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 i
> can get a msg box to popup and ask them if they want to add that to the
> accounts.
>
> The problem i am having is i am trying to use the exit event in the
> cboPayable. And when i exit or tab from that field( and the value
> doesn't match then) a microsoft message box appears that says invalid
> property use. then my msg box comes up. But not until i close all
> forms. is there anywya to bypass this message from microsoft.
>
> Thanks for any help
>
>
> --
> jhahes
> ------------------------------------------------------------------------
> jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
> View this thread: http://www.excelforum.com/showthread...hreadid=477585
>
>