rhombus4
Well-known Member
- Joined
- May 26, 2010
- Messages
- 586
- Office Version
- 365
- 2016
- Platform
- Windows
Have a few comboboxes on a form and have tried both options below which do work and restrict entries.
However what if I enter a dropdown by mistake and then decide I didn't want to and I want it to be cleared, it wont let me clear the selection.
The only workaround is possibly to add a space at the top of the named range so you could select that instead, but was wondering if there is an easy way maybe in the properties or something I could set at initialisation
Set MatchRequired to True - Allows you to type in the combo box, but limits the entry to the defined range.
Set Style property to fmStyleDropDownList - Can't type, but limits the entry to the defined range.
Not sure if there is a big difference between the two options or which one is the best
However what if I enter a dropdown by mistake and then decide I didn't want to and I want it to be cleared, it wont let me clear the selection.
The only workaround is possibly to add a space at the top of the named range so you could select that instead, but was wondering if there is an easy way maybe in the properties or something I could set at initialisation
Set MatchRequired to True - Allows you to type in the combo box, but limits the entry to the defined range.
Set Style property to fmStyleDropDownList - Can't type, but limits the entry to the defined range.
Not sure if there is a big difference between the two options or which one is the best