Validate typed-in value against in-cell dropdown list
It (XL2003) only values (to be typed) which are in the List so it is
self-validating.
" wrote:
Hi Toppers,
The user prefers it although it wasn't a hard requirement. To some of
them, typing it in is faster than using a mouse since they do it so
often.
Besides, when I used Data / Validation to set up the list, by default,
it allows the user to type in the value.
Thanks.
|