+ Reply to Thread
Results 1 to 3 of 3

List drop down

  1. #1
    Registered User
    Join Date
    02-05-2004
    Posts
    48

    List drop down

    Hi - hoping someone can help.

    I have a drop down list (of text) within my spreadsheet. I would like the list to be able to accept manual unique entries, ie those not part of the list, as well as those that are part of the list.

    When I try and do this there is an error message - 'the value you entered is not from the required list'.

    Is there a way I can manually override this and input a unique text string?

    many thanks

  2. #2
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    I assume this is just a data validation list? If so, select the cell(s), select Data > Validation from the menu. Then on the 'Error Alert' tab, uncheck the 'show error' option. Or, you could just change from 'Stop' to 'Warning' or 'Information' if you still want a message to pop up, but will allow changing.

  3. #3
    Registered User
    Join Date
    02-05-2004
    Posts
    48
    Thanks Jason - works a treat!

+ Reply to Thread

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