I
IanC
I have several ComboBoxes on a form.
These ComboBoxes are populated from ranges specified in RowSource.
Initially the ComboBoxes display Select as set by the Value property.
If the user selects from the available options there is no problem as the
subsequent code recognises the input.
When all the relevant data is selected, an OK button is enabled. If not,
then there is only a Cancel button.
If the MatchRequired property is set to True, clicking the Cancel button on
the form displays "Invalid property value" and the code associated with the
Cancel button fails to execute.
I suspect it is connected with each of the ComboBoxes initially containing
"Select" even though this is not in the RowSource range.
I think I have 2 options:
1. Set MatchRequired to False. Unfortunately this allows the user to type
into the ComboBox, potentially causing the subsequent code to crash.
2. Add "Select" to the range specified in RowSource. This means that
"Select" will appear in the and is a relatively minor issue.
Is there a 3rd way? Ideally I'd like to disable the option to type into the
ComboBox. I know I could use a ListBox, but I can't enter "Select" initially
unless it's in the specified range, in which case I'm better going with
option 2 as the ComboBoxes are already in place.
These ComboBoxes are populated from ranges specified in RowSource.
Initially the ComboBoxes display Select as set by the Value property.
If the user selects from the available options there is no problem as the
subsequent code recognises the input.
When all the relevant data is selected, an OK button is enabled. If not,
then there is only a Cancel button.
If the MatchRequired property is set to True, clicking the Cancel button on
the form displays "Invalid property value" and the code associated with the
Cancel button fails to execute.
I suspect it is connected with each of the ComboBoxes initially containing
"Select" even though this is not in the RowSource range.
I think I have 2 options:
1. Set MatchRequired to False. Unfortunately this allows the user to type
into the ComboBox, potentially causing the subsequent code to crash.
2. Add "Select" to the range specified in RowSource. This means that
"Select" will appear in the and is a relatively minor issue.
Is there a 3rd way? Ideally I'd like to disable the option to type into the
ComboBox. I know I could use a ListBox, but I can't enter "Select" initially
unless it's in the specified range, in which case I'm better going with
option 2 as the ComboBoxes are already in place.