Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: select multiple values from a drop down list

  1. #1
    Join Date
    27th September 2004
    Posts
    3

    select multiple values from a drop down list

    Hi

    i need to create a drop down list in a cell, where i can select multiple values from the drop down list (like a checklist) and all the values that i select should then appear in that cell.

    thanks

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,709
    Hi suboor

    Welcome to ozgrid.com

    You need to use a ListBox from the Control Toolbox Toolbar. It will also need VBA code to transfer any selections.

    Post back if you need an example.

  3. #3
    Join Date
    27th September 2004
    Posts
    3

    select multiple values from a drop down list

    thanx

    could you please show me an example.

    regards

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,709
    See attached example
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

  5. #5
    Join Date
    27th September 2004
    Posts
    3
    hi

    thanx for that example on multple select from checklist, however, that example populates a different cell for each selection,
    can i make the selection(s) appear within a single cell?

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,709
    Sure can, see the modified attachment.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Drop Down List Returning Multiple Values?
    By _W0lf_ in forum EXCEL HELP
    Replies: 8
    Last Post: July 6th, 2010, 21:34
  2. Replies: 3
    Last Post: March 18th, 2007, 11:25
  3. Select an Image from a drop down list
    By chris_hart03 in forum EXCEL HELP
    Replies: 1
    Last Post: September 21st, 2005, 12:39
  4. Select value in drop down list
    By good4u in forum EXCEL HELP
    Replies: 2
    Last Post: May 5th, 2005, 18:45
  5. Select Formulas from Drop-Down List
    By Fin Fang Foom in forum EXCEL HELP
    Replies: 14
    Last Post: April 19th, 2005, 07:36

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
  •  
porno