Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limit entries to combobox
I have a combox box on a form, and let's say it is populated with the months
of the year. I've left it blank, so that as the user types "J a " then January pops up. How can I stop the user for typing in a word that isn't in the dropdown list? Let's say they type "Decmeber" (so they spell it wrong"). Is there a bit of quick looping code to check whether the entry is valid? Also, there are 12 comboboxes on my form, so if there is a way to handle all of them efficiently, even better! Thanks in advance, Daniel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limit entries to combobox
Daniel,
Look at the .Style, .MatchEntry and .MatchRequired properties of the combobox. NickHK "Daniel Bonallack" wrote in message ... I have a combox box on a form, and let's say it is populated with the months of the year. I've left it blank, so that as the user types "J a " then January pops up. How can I stop the user for typing in a word that isn't in the dropdown list? Let's say they type "Decmeber" (so they spell it wrong"). Is there a bit of quick looping code to check whether the entry is valid? Also, there are 12 comboboxes on my form, so if there is a way to handle all of them efficiently, even better! Thanks in advance, Daniel |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limit entries to combobox
Hi Nick, you've been my saviour today - thanks!
"NickHK" wrote: Daniel, Look at the .Style, .MatchEntry and .MatchRequired properties of the combobox. NickHK "Daniel Bonallack" wrote in message ... I have a combox box on a form, and let's say it is populated with the months of the year. I've left it blank, so that as the user types "J a " then January pops up. How can I stop the user for typing in a word that isn't in the dropdown list? Let's say they type "Decmeber" (so they spell it wrong"). Is there a bit of quick looping code to check whether the entry is valid? Also, there are 12 comboboxes on my form, so if there is a way to handle all of them efficiently, even better! Thanks in advance, Daniel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
item limit for a combobox? | Excel Worksheet Functions | |||
IF command, limit to number of entries? | Excel Worksheet Functions | |||
combobox limit to list | Excel Programming | |||
limit column entries | Excel Worksheet Functions | |||
limit column entries | Excel Discussion (Misc queries) |