Yes, you're quite right, I don't think I'm using it to the best of its ability.
Thanks for the link.
Louise

"Bob Phillips" wrote:

If you go into Data Validation, the first dropdown, named Allow, provides
the types of validation that you can set. If you choose List, you can refer
to a list of allowable values, or even type them in directly.

A better question is why not use Data Validation. It is a great facility,
and should be used more. Debra Dalgleish has details on her website at
http://www.contextures.com/xlDataVal01.html

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Louise" wrote in message
...
Hello, thank you for your reply.

What do you mean 'allow a choice from a list'?

Louise

" wrote:

Any manner of reasons
(1) Allow a choice from a list
(2) restrict entry to ONLY dates - thus stopping people typing 01.01.01
and thinking it's a date
(3) Restrict the length of entry - for many of my applications, a value
entered must always be a given length
(4) even without a rule, Data Validation allows you to give
instructions to the user