Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combobox - MatchRequired does not work? | Excel Programming | |||
Call a UserForm based on ComboBox selection | Excel Programming | |||
Custom error-message for MatchRequired ComboBox | Excel Programming | |||
OLE Combobox MatchRequired property not working | Excel Programming | |||
Userform: Textbox changing with selection in combobox (list) | Excel Programming |