D
Dave
Hi
I have a userform with some combo boxes. The combo boxes are set to match
the entry to the defined row source.
If a user clicks into the combo box, but does not enter anything, and then
moves off the dropdown, I get the "Invalid Property Error" dialogue box even
tho nothing has been entered. I obviously thinks i am trying to enter
"blank".
Is there a way I can either prevent this error showing, by changing a
setting (I need to match against the list tho, to prevent erronious
entries). If I cannot do this by a setting, can I either cancel it in VBA,
or at least replace the system error dialogue, with my own msgbox. I know i
could add a blank to the list on the control, but dont really want to do
this.
Ideally, I would like to cancel the error msg altogether. I have tried the
various event options, but cant seem to find the one that handles the error
concerned.
Thanks for any help
I have a userform with some combo boxes. The combo boxes are set to match
the entry to the defined row source.
If a user clicks into the combo box, but does not enter anything, and then
moves off the dropdown, I get the "Invalid Property Error" dialogue box even
tho nothing has been entered. I obviously thinks i am trying to enter
"blank".
Is there a way I can either prevent this error showing, by changing a
setting (I need to match against the list tho, to prevent erronious
entries). If I cannot do this by a setting, can I either cancel it in VBA,
or at least replace the system error dialogue, with my own msgbox. I know i
could add a blank to the list on the control, but dont really want to do
this.
Ideally, I would like to cancel the error msg altogether. I have tried the
various event options, but cant seem to find the one that handles the error
concerned.
Thanks for any help