| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match Entry
Hello:
I have an active x combo box with the style set to fmstyledropdowncombo, and match entry is set to fmmatchcomplete. However I want the user entry to match with the list from the listfillrange. I set matchentry to "true" but I can still type whatever I want and go away from the combo box and it will not force a match? Why is it like this? Is match entry not supposed to require a match? Please help. Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Match Entry
G'day Art
Rather than a ComboBox, why not use DataValidation, this way the user can only select from a pre-defined list that you set. HTH Mark |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Match Entry
You could just change the style to fmStyleDropDownList.
art wrote: Hello: I have an active x combo box with the style set to fmstyledropdowncombo, and match entry is set to fmmatchcomplete. However I want the user entry to match with the list from the listfillrange. I set matchentry to "true" but I can still type whatever I want and go away from the combo box and it will not force a match? Why is it like this? Is match entry not supposed to require a match? Please help. Thanks. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If cell entry does not match options = error | Excel Discussion (Misc queries) | |||
| entry must match value in range | Excel Worksheet Functions | |||
| How to align cells in a column to match the entry in col A | Excel Programming | |||
| Match and find entry | Excel Programming | |||
| How do I set up Data entry to match My Application Form | Excel Discussion (Misc queries) | |||
Hybrid Mode
