LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 395
Default Userform combobox matchrequired = True; error with no selection

I have a userform that includes a combobox which is optional for the user,
but if they do use it, they have to select one of the three values provided
(no creativity allowed).

This works fine if the user ignores the field, or if they make a selection.
They can even click the combobox 'arrow' to see the values and then click to
another part of the form without making a selection. They can tab through
controls including this one without any problem. All good.

However, a user may enter the field (mouseclick) thinking they might want to
make a selection, then decide against it. In those cases, they should be able
to click on another control, tab away, or click the submit or cancel
commandbuttons on the form without error.

However, the actual behavior is that once the combobox field is entered by
the cursor via a mouse click, a selection is required. Attempting to leave
the combobox without a selection results in the error "Microsoft Forms:
Invalid property value"

Is there a different way to set up the combobox that avoids this error? I do
not want to offer the user a "blank" value, because after making a selection
they are not allowed to remove it (they can change it to another of the three
values, they just aren't allowed to blank it out again). I'd be happy if
there was a way to block the mouse from selecting (setfocus?) within the
combobox as long as they could still select the combobox downarrow and select
a value from there.

Thank you,
Keith
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combobox - MatchRequired does not work? Wim SKW Excel Programming 2 December 7th 09 02:01 PM
Call a UserForm based on ComboBox selection DJ Excel Programming 4 July 10th 08 11:38 PM
Custom error-message for MatchRequired ComboBox Gert-Jan Excel Programming 1 June 21st 06 09:51 PM
OLE Combobox MatchRequired property not working Michael Deathya Excel Programming 4 January 29th 05 11:07 PM
Userform: Textbox changing with selection in combobox (list) NorTor[_3_] Excel Programming 3 June 8th 04 10:19 PM


All times are GMT +1. The time now is 03:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"