View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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.