combobox querie

[funkymonkUK]

I have a query. I got a userform with a combobox. on the properties I have the matchrequired as true and matchentry as 0-fmmatchentrycomplete. now if i leave the combobox empty it keeps coming up with an error saying invalid property. I figured that maybe it was because I do not have a blank entry in my list so I added a blank entry but it still seems to come up again. I am using setfocus once the user has finished entrying in the figure and press the ok commandbutton which is setforcused to the combobox.

Could you help me?

[Dave Peterson]

Maybe making the .matchrequired = false, but changing the
..style = 2- fmStyleDropDownList would be sufficient.

funkymonkUK wrote:
>
> I have a query. I got a userform with a combobox. on the properties I
> have the matchrequired as true and matchentry as
> 0-fmmatchentrycomplete. now if i leave the combobox empty it keeps
> coming up with an error saying invalid property. I figured that maybe
> it was because I do not have a blank entry in my list so I added a
> blank entry but it still seems to come up again. I am using setfocus
> once the user has finished entrying in the figure and press the ok
> commandbutton which is setforcused to the combobox.
>
> Could you help me?
>
> --
> funkymonkUK
> ------------------------------------------------------------------------
> funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
> View this thread: http://www.excelforum.com/showthread...hreadid=467454

--

Dave Peterson