Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 30th 08, 09:48 PM posted to microsoft.public.excel.worksheet.functions
VLH VLH is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2008
Posts: 7
Default Drop Down List - Select Multiple Items

I need to select multiple items from a drop-down list that I created because
there are times where more than one item is needed.

For example, my drop-down list might contain the following:
apples, oranges, pears, lemons, mangos

I want the data cell to show that I selected: apples, oranges, pears (for
example).

Is this possible?

  #2   Report Post  
Old April 30th 08, 10:00 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
Posts: 1,533
Default Drop Down List - Select Multiple Items

Hi

If you use a List Box it's possible to allow mulit select.

Open the properties window and find the field MultiSelect and enter the
value to "1 - fmMultiSelectMulti"

Regards,
Per

"VLH" skrev i meddelelsen
...
I need to select multiple items from a drop-down list that I created
because
there are times where more than one item is needed.

For example, my drop-down list might contain the following:
apples, oranges, pears, lemons, mangos

I want the data cell to show that I selected: apples, oranges, pears (for
example).

Is this possible?


  #3   Report Post  
Old April 30th 08, 10:20 PM posted to microsoft.public.excel.worksheet.functions
VLH VLH is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2008
Posts: 7
Default Drop Down List - Select Multiple Items

Hello,
Can you instruct me on where to find the "properties window" please?
Thanks!

"Per Jessen" wrote:

Hi

If you use a List Box it's possible to allow mulit select.

Open the properties window and find the field MultiSelect and enter the
value to "1 - fmMultiSelectMulti"

Regards,
Per

"VLH" skrev i meddelelsen
...
I need to select multiple items from a drop-down list that I created
because
there are times where more than one item is needed.

For example, my drop-down list might contain the following:
apples, oranges, pears, lemons, mangos

I want the data cell to show that I selected: apples, oranges, pears (for
example).

Is this possible?



  #4   Report Post  
Old May 1st 08, 12:49 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Drop Down List - Select Multiple Items

See Debra Dalgleish's site for a workbook download showing how to select
multiple items from a DV list.

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

http://www.contextures.on.ca/excelfiles.html#DataVal


Gord Dibben MS Excel MVP

On Wed, 30 Apr 2008 13:48:01 -0700, VLH wrote:

I need to select multiple items from a drop-down list that I created because
there are times where more than one item is needed.

For example, my drop-down list might contain the following:
apples, oranges, pears, lemons, mangos

I want the data cell to show that I selected: apples, oranges, pears (for
example).

Is this possible?


  #5   Report Post  
Old May 1st 08, 03:59 PM posted to microsoft.public.excel.worksheet.functions
VLH VLH is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2008
Posts: 7
Default Drop Down List - Select Multiple Items

I have viewed Debra's DV0017 workbook and the instructions only say to
right-click on the worksheet tab to view the code. It doesn't tell me what
function to place in my worksheet so that I receive multiple items from a
drop-down. Please help me understand what I should do with Debra's DV0017 to
ensure I get multiple items from a drop-down into my worksheet. Thanks!

"Gord Dibben" wrote:

See Debra Dalgleish's site for a workbook download showing how to select
multiple items from a DV list.

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

http://www.contextures.on.ca/excelfiles.html#DataVal


Gord Dibben MS Excel MVP

On Wed, 30 Apr 2008 13:48:01 -0700, VLH wrote:

I need to select multiple items from a drop-down list that I created because
there are times where more than one item is needed.

For example, my drop-down list might contain the following:
apples, oranges, pears, lemons, mangos

I want the data cell to show that I selected: apples, oranges, pears (for
example).

Is this possible?





  #6   Report Post  
Old May 2nd 08, 01:17 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Drop Down List - Select Multiple Items

You need to set a cell or cells as a DV Dropdown with a list then alter the code
to point to that DV Dropdown cell or column.

From your original post I believe you should concentrate on the Comma Separated
worksheet code

Perhaps you should see Debra's site for how to create a DV dropdown list first
before altering any of her code.

http://www.contextures.on.ca/xlDataVal01.html

Now, to the workbook you downloaded......................

Have you tested by clicking on one of the DV dropdowns on the Comma Separated
sheet. Debra provides with the MultiSelect workbook.

Where will your DV dropdown cells be located?

Where will you store the DV list?

These I need to know before going any further but you could experiment with
changing this line

If Target.Column = 3 Then..........the 3 points to any DV Dropdown in Column C

Change to your column.


Gord

On Thu, 1 May 2008 07:59:00 -0700, VLH wrote:

I have viewed Debra's DV0017 workbook and the instructions only say to
right-click on the worksheet tab to view the code. It doesn't tell me what
function to place in my worksheet so that I receive multiple items from a
drop-down. Please help me understand what I should do with Debra's DV0017 to
ensure I get multiple items from a drop-down into my worksheet. Thanks!

"Gord Dibben" wrote:

See Debra Dalgleish's site for a workbook download showing how to select
multiple items from a DV list.

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

http://www.contextures.on.ca/excelfiles.html#DataVal


Gord Dibben MS Excel MVP

On Wed, 30 Apr 2008 13:48:01 -0700, VLH wrote:

I need to select multiple items from a drop-down list that I created because
there are times where more than one item is needed.

For example, my drop-down list might contain the following:
apples, oranges, pears, lemons, mangos

I want the data cell to show that I selected: apples, oranges, pears (for
example).

Is this possible?




  #7   Report Post  
Old June 9th 08, 10:40 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 1
Default Drop Down List - Select Multiple Items

On May 1, 6:49*am, Gord Dibben <gorddibbATshawDOTca wrote:
See Debra Dalgleish's site for a workbook download showing how to select
multiple items from a DV list.

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

http://www.contextures.on.ca/excelfiles.html#DataVal

Gord Dibben *MS Excel MVP



On Wed, 30 Apr 2008 13:48:01 -0700, VLH wrote:
I need to select multiple items from a drop-down list that I created because
there are times where more than one item is needed. *


For example, my drop-down list might contain the following:
apples, oranges, pears, lemons, mangos


I want the data cell to show that I selected: apples, oranges, pears (for
example).


Is this possible? *- Hide quoted text -


- Show quoted text -


Dear Gord Dibben,

I've got the same problem and while searching on the Internet to find
out anyway to get a drop-down list with check-box element inside, I
found this article but it is still not exactly what I would like to
have..

I've already seen somebody using a speadsheet with a multichoice drop-
down list, it looks like a autofilter fucntion and allow you to select
more than one criteria for your filtration. when you click on the
arrow on right side of the cell, it show you a drop-down list with all
the check-boxes in side the list, then you can select whatever item by
click on approriate checkbox. And at the bottom of the dropdown list,
there is 2 buttons, OK and Cancel, if you select OK, then the
Filtration process will start with all the criteria you've selected in
checkboxes inside that drop-down list.

I really want to know how to get this done, even by VBA macro but I
could not find anything like this on the internet. I really
appreciated if you can help me to point out where is the right
direction to find any solutions for this problem.

Thank you very much and look forward to your feedback soon..

Best regards,
Hao.
  #8   Report Post  
Old June 10th 08, 12:03 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Drop Down List - Select Multiple Items

I am not familiar with what you describe.

Note: I do not do much programming so my knowledge is limited.

Perhaps someone will recognize the process from your description?

Maybe a userform or similar?


Gord

On Mon, 9 Jun 2008 02:40:45 -0700 (PDT), wrote:

I've got the same problem and while searching on the Internet to find
out anyway to get a drop-down list with check-box element inside, I
found this article but it is still not exactly what I would like to
have..

I've already seen somebody using a speadsheet with a multichoice drop-
down list, it looks like a autofilter fucntion and allow you to select
more than one criteria for your filtration. when you click on the
arrow on right side of the cell, it show you a drop-down list with all
the check-boxes in side the list, then you can select whatever item by
click on approriate checkbox. And at the bottom of the dropdown list,
there is 2 buttons, OK and Cancel, if you select OK, then the
Filtration process will start with all the criteria you've selected in
checkboxes inside that drop-down list.

I really want to know how to get this done, even by VBA macro but I
could not find anything like this on the internet. I really
appreciated if you can help me to point out where is the right
direction to find any solutions for this problem.

Thank you very much and look forward to your feedback soon..

Best regards,
Hao.


  #9   Report Post  
Old January 9th 14, 06:07 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2014
Posts: 1
Default Drop Down List - Select Multiple Items

Hi Hao,

Were you able to find a solution to your problem of having a list of checkboxes in a dropdown list in excel?

Thanks
Anubha
  #10   Report Post  
Old January 15th 14, 10:45 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2014
Posts: 1
Default Drop Down List - Select Multiple Items

I realize this thread is kind of old but I was just trying to figure out the same and figured it out. I'm on Office 2010, just go tthe "data" tab and then click on the "filter" button. On my spreadsheet it automatically pulled all the column data and created the checkbox. hope this helps.

On Wednesday, January 8, 2014 9:07:41 PM UTC-8, wrote:
Hi Hao,



Were you able to find a solution to your problem of having a list of checkboxes in a dropdown list in excel?



Thanks

Anubha




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
selecting multiple items from drop-down list [email protected] Excel Discussion (Misc queries) 1 October 25th 07 01:24 PM
Can I create a dropdown list to select multiple items Oct1196 Excel Worksheet Functions 2 September 5th 07 08:19 PM
Selecting multiple items from a drop down list Jeremy Excel Discussion (Misc queries) 4 December 11th 06 03:53 PM
select multiple items from a dropdown list Rebecca1 Excel Worksheet Functions 0 July 17th 06 08:47 PM
multiple select from the drop down list in excel. list in one sheet and drop down in sriramus Excel Discussion (Misc queries) 5 October 27th 05 06:55 PM


All times are GMT +1. The time now is 08:24 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017