Limit data entered to list (drop-down control)

G

Guest

Hello,

I have not used the data validation function in excel because I need to
change the font/language of the drop-down list. As suggested by this forum
(thanks!), I have used the drop-down list control to achieve this. However,
now I cannot stop the user from entering data that is different to what is in
the list (ListFillRange). I have tried the "match required" property but
this has no effect.

Any hints as to how I can limit the user's selection to the list
(ListFillRange) while using a drop-down list control? (Essentially, I want it
to behave as the LimitTopList property in access).

Thanks,
Ronnie.
 
N

NickH

Have a look at the properties of your dropdown list/ComboBox. You
should be able to change the 'MatchRequired' property to 'True'

HTH,
NickH
 
C

Chip Pearson

Set the ListFillRange property to your list of cells, and change
the Style property to 2 - StyleFileDropDownList. This will limit
input to only the values in the ListFileRange.



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pick from drop-down list gives empty or erroneous result 6
Open Specific Worksheet Using Button Form Control in Excel 0
How to dynamically change the list in drop down list based on thevalue of another cell? 1
Drop Down List Format 2
Calculate according to Drop Down control list value 1
Data Validation drop down list query 3
Drop Down Menu Help 3
limiting selections in drop down list 2

Top