+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : Excel 2003 - Multiple chooice in drop down menu (list)

  1. #1
    Registered User
    Join Date
    07-21-2009
    Location
    Zagreb
    MS-Off Ver
    Excel 2003
    Posts
    3

    Excel 2003 - Multiple chooice in drop down menu (list)

    All,
    I hope that someone can help me with this request:

    Have excel with 2 spreedsheet (Mastersheet + Report Sheet) need to enable in drop down menu where is possible to select multiple chooice. So I have list of attendies in Mastersheet and need to have possibility to select certan number of attendies who were at particular training.

    I'm waiting for your suggestions and inputs

    Thanks a lot in advance!

    Cheers!

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Excel 2003 - Multiple chooice in drop down menu (list)

    http://www.contextures.com/excelfiles.html

    DV0017 - Select Multiple Items from Dropdown List-- Select multiple items from a dropdown list; an event macro stores selections in adjacent cell, or in same cell. DataValMultiSelect.zip 18kb updated 22-Feb-07
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    07-21-2009
    Location
    Zagreb
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Excel 2003 - Multiple chooice in drop down menu (list)

    Quote Originally Posted by JBeaucaire View Post
    http://www.contextures.com/excelfiles.html

    DV0017 - Select Multiple Items from Dropdown List-- Select multiple items from a dropdown list; an event macro stores selections in adjacent cell, or in same cell. DataValMultiSelect.zip 18kb updated 22-Feb-07
    Excellent, just if you can suggest changes to code for SameCall, to be able just to select one user in one cell, not to double them. What else would be super cool to number each selection, so for example to have 1.One, 2.Two, 3.Three etc.

    Sorry if I'm asking too much

    Thx

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Excel 2003 - Multiple chooice in drop down menu (list)

    I had completely forgotten I had published a multiple-choice DV macro on my site.
    Multiple Choice Data Validation

    I've updated that page to include two more options along the lines of what you're looking for.

+ 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