Limit a cell data entry to combobox list in Excel 1

[Mrexcel]

I'm using a combobox list to select a value for a cell, i want that the user cannot enter any other data to this cell, only thru the list.
When i try to select the entry from the combobox list, and if by mistake i enter any character, it will go to the cell.
So please how can i be sure that the selected value is part of the list.
Note: the list is loaded thru a macro and contains more than 3000 elements.
Thanks for your help.

 

[ilses]

Assuming it's a combo from the Toolbox, set it's MatchRequired property to True.

3000 Entries? That's a lot ...

Best regards,


ilses

 

[DaleWatson123321]

Mrexcel,

Just a thought... perhaps useful "food for thought" for an alternative approach.

From your description, I understand that you have a situation where the user is expected to pick from a list that is 3,000 items long. That seems like it could be quite a laborious task.

If this is the case, what about the possibility of FIRST setting up a "prompt" for a "key word" (or words). Then, the result of the user's input would result in those records which contain the "key word(s)" being extracted to a "condensed list" which would subsequently be displayed in a combobox list.

Hope this helps. Please advise. If you decide to go this route, let me know if you need help with code for the "extraction".

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca