ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Match Entry (https://www.excelbanter.com/excel-programming/420159-match-entry.html)

Art

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.

NoodNutt

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



Dave Peterson

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