LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 110
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
item limit for a combobox? KarenH Excel Worksheet Functions 3 July 20th 06 09:30 PM
IF command, limit to number of entries? timhiley Excel Worksheet Functions 2 December 10th 05 12:54 AM
combobox limit to list tmort[_5_] Excel Programming 4 July 26th 05 08:45 PM
limit column entries Boenerge Excel Worksheet Functions 4 May 8th 05 08:02 PM
limit column entries Boenerge Excel Discussion (Misc queries) 2 May 8th 05 07:14 PM


All times are GMT +1. The time now is 02:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"