Results 1 to 7 of 7

Data Validation List, disallow if not in list

Threaded View

  1. #1
    Registered User
    Join Date
    07-16-2009
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    4

    Data Validation List, disallow if not in list

    I am using Data Validation on some fields to create a drop down list from a named range! These fields however allow you to enter values that are not in the list.

    Is there a way to make the cell have to be an entry from the data validation list?
    Last edited by QCBeauty; 07-20-2009 at 01:31 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1