Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
VLH VLH is offline
external usenet poster
 
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  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
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  
Posted to microsoft.public.excel.worksheet.functions
VLH VLH is offline
external usenet poster
 
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  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
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  
Posted to microsoft.public.excel.worksheet.functions
VLH VLH is offline
external usenet poster
 
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  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
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  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
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  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
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  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
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  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
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




  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Drop Down List - Select Multiple Items

<scripthi</script
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Drop Down List - Select Multiple Items

On Wednesday, April 30, 2008 5:00:02 PM UTC-4, 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?


I have also been trying to be able to select multiple items from a drop-down menu and have them show up in the same cell and cannot figure out how it is done. Where is the "properties window?" Is this a change that should be applied to the entire document or should the column with the drop-down menu be highlighted when I enter the "1 - fmMultiSelectMulti" value?
  #15   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Drop Down List - Select Multiple Items

On Wednesday, 30 April 2008 21:48:01 UTC+1, 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?


--


Wm Morrison Supermarkets Plc is registered in England with number 358949.
The registered office of the company is situated at Gain Lane, Bradford,
West Yorkshire BD3 7DL. This email and any attachments are intended for the
addressee(s) only and may be confidential.


If you are not the intended
recipient, please inform the sender by replying to the email that you have
received in error and then destroy the email.
If you are not the intended
recipient, you must not use, disclose, copy or rely on the email or its
attachments in any way.


This email does not constitute a contract in
writing for the purposes of the Law of Property (Miscellaneous Provisions)
Act 1989.


Our Standard Terms and Conditions of Purchase, as may be
amended from time to time, apply to any contract that we enter into. The
current version of our Standard Terms and Conditions of Purchase is
available at:http://www.morrisons.co.uk/gscop
<http://www.morrisons.co.uk/gscop


Although we have taken steps to ensure
the email and its attachments are virus-free, we cannot guarantee this or
accept any responsibility, and it is the responsibility of recipients to
carry out their own virus checks.


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 12:46 PM.

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

About Us

"It's about Microsoft Excel"