Limit data entered to list (drop-down control)
 

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.

Limit data entered to list (drop-down control)
 

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

HTH,
NickH

Limit data entered to list (drop-down control)
 

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

"Ronnie" wrote in message
...
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.

Limit data entered to list (drop-down control)
 

Hi Ronnie,
This page or the links may be of help...

http://www.contextures.com/xlDataVal01.html

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=541488