![]() |
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. |
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 |
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 |
All times are GMT +1. The time now is 04:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com