+ Reply to Thread
Results 1 to 2 of 2

Multiple correct in data validation drop down box

  1. #1
    Registered User
    Join Date
    05-30-2008
    Posts
    32

    Multiple correct in data validation drop down box

    Hello,

    I need to know how to have multiple correct responses in a data validation drop down box. For instance, here is my list:
    As needed
    Daily
    Weekly
    As ordered by Physician

    Any combination, including all four could be the correct response and would need to show on the spread sheet as a chosen response.

    Can anyone help me?

    Carla

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372
    Hi,

    if you use data validation with a list, you can only select one of the choices on offer. The functionality you're after calls out for a multiple choice tick box, but I'm not sure if you want to go down the VBA track with Userforms.

    For a VBA free solution you either need to include all possible combinations in your list (which would make it quite long), or have four separate cells where the user can select the values, for example

    cell/column1
    as needed

    cell/column2
    daily

    cell/column3
    weekly

    cell/column4
    as ordered by physician

    The user fills in as many cells/columns as apply in the case and if only two values are selected, the other two cells/columns simply stay blank.

    Would that work?

    cheers

    Teylyn

+ 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