combobox querie
 

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

combobox querie
 

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