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.