+ Reply to Thread
Results 1 to 3 of 3

Make a drop down list (I.E. from Data Validation) that can also accept any value

  1. #1
    Registered User
    Join Date
    02-28-2012
    Location
    ohio
    MS-Off Ver
    Excel 2003
    Posts
    2

    Make a drop down list (I.E. from Data Validation) that can also accept any value

    Hi All,

    A form for the lab, we want a drop down list with common entries but also want people to be able to enter an "other" value. I have the drop down list working fine, but I cant see how to let people enter an "other value". Right now I just have "Other" as an option and then another column where they can fill in the other value, but this is ugly and people dont like it.
    Thanks everyone!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-28-2012
    Location
    ohio
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Make a drop down list (I.E. from Data Validation) that can also accept any value

    It seems to be working for the first drop down list but I have no idea how I got that, and can't seem to reproduce it.

  3. #3
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Make a drop down list (I.E. from Data Validation) that can also accept any value

    if you include in your range for the data validation a blank cell, you will be allowed to enter any value you want.
    If you liked my solution, please click on the Star -- to add to my reputation

    If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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