+ Reply to Thread
Results 1 to 4 of 4

Multiple selection from validation list in one box

Hybrid View

  1. #1
    Registered User
    Join Date
    04-15-2013
    Location
    Aalborg, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    1

    Multiple selection from validation list in one box

    Hi

    I have created a validation list, and I have to enable it so the user of my template can choose multiple items from my drop-down list (I want it to be in one box seperated by comma).

    First of all I have to say I am a newbie when it comes to excel, so its my first time to hear about VBA, and I don't know anything about coding at all, so I'm don't feel like the sharpest knife in the drawer right now:D

    I found some different codes online which I tried to use without any success. So I hope that there is some who can help me with the coding.

    The column in which I need the multiple selection choice is in column F(29-38).

    Hope that there is some excel shark out there who can help me.

    Thanks in advance
    Maria

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Multiple selection from validation list in one box

    You can't do multiple selection in Validation List


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Valued Forum Contributor
    Join Date
    09-04-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    463

    Re: Multiple selection from validation list in one box

    http://www.contextures.com/excel-dat...-multiple.html

    check the above link and download the file " Select Multiple Items from Excel Data Validation List" there...........
    then after check the "same cell" sheet

    there you will get your answer........

    If it was really helpful then dont forget to hit * button for user reputation........

    Regards
    CA Mahaveer Somani

  4. #4
    Registered User
    Join Date
    05-17-2012
    Location
    dubai
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Multiple selection from validation list in one box

    Can someone make multiple selections from the same list.. For example-if im filtering for HR and Finance employee data, can i select both at the same time?

+ 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