LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
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.




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
validate multiple cells in to one dropdown box shad Excel Discussion (Misc queries) 3 April 15th 07 10:02 PM
result of selecting from the dropdown list should be a dropdown list No News Excel Worksheet Functions 0 July 5th 06 04:09 PM
Validate all cell values against it's list prior to saving the she Hippy Excel Programming 2 January 16th 06 05:33 PM
Validate cell value against a list Hippy Excel Programming 2 December 7th 05 05:26 PM
How to validate data in already list dropdown validated. Rao Ratan Singh Excel Discussion (Misc queries) 2 June 14th 05 01:32 PM


All times are GMT +1. The time now is 11:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"