Limit data entered to list (drop-down control)

[Ronnie]

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.

[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

[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

"Ronnie" <[email protected]> wrote in message
news:[email protected]...
> 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.

[broro183]

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...