Limit data entered to list (drop-down control)

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Have a look at the properties of your dropdown list/ComboBox. You
should be able to change the 'MatchRequired' property to 'True'

HTH,
NickH
 
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
 
Back
Top