Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 32
Default List to select up to 6 selected responses

Is it possible to create a list in excel 2003 and allow up to 6 items on the
list to be selected and have them displayed in the cell?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default List to select up to 6 selected responses

Maybe you coud use Data|Validation.

Debra Dalgleish has lots of tips:
http://contextures.com/xlDataVal01.html



Ellen wrote:

Is it possible to create a list in excel 2003 and allow up to 6 items on the
list to be selected and have them displayed in the cell?


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 32
Default List to select up to 6 selected responses

I looked at data validation. From what I could see, using Allow list I was
only able to select 1 item and not several.

Ellen

"Dave Peterson" wrote:

Maybe you coud use Data|Validation.

Debra Dalgleish has lots of tips:
http://contextures.com/xlDataVal01.html



Ellen wrote:

Is it possible to create a list in excel 2003 and allow up to 6 items on the
list to be selected and have them displayed in the cell?


--

Dave Peterson

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default List to select up to 6 selected responses

Sorry.

I thought that the the list could contain up to 6 items and that you'd select
one of those six.

You'll need a macro.

If that's ok...

Maybe you could use a listbox from the Forms Toolbar and a button from that same
Forms toolbar.

I put a listbox from the forms toolbar on a worksheet and put a button from the
forms toolbar right near it.

I right clicked on the listbox and chose format control.

Then on the Control tab, I assigned an input range (from another worksheet in my
test) and chose Multi in the selection type area.

Then I added a button from the Forms toolbar.

And I added this code to a General module in the workbook's project.

Option Explicit
Sub testme()
Dim iCtr As Long
Dim myLB As ListBox
Dim myStr As String
Dim myCell As Range

Set myLB = ActiveSheet.ListBoxes("List box 1")

Set myCell = ActiveSheet.Range("a1") 'Activecell '????

With myLB
For iCtr = 1 To .ListCount
If .Selected(iCtr) Then
myStr = myStr & vbLf & .List(iCtr)
End If
Next iCtr
End With

If myStr < "" Then
myStr = Mid(myStr, 2)
End If

myCell.Value = myStr

End Sub

And then back to excel.
I rightclicked on the button and assigned this macro to that button.

I wasn't sure what you really wanted--did you want all the selected items in a
single cell?

That's what the code does. The selected items are separated by alt-enters.

And I put that string in A1 of the activesheet.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


Ellen wrote:

I looked at data validation. From what I could see, using Allow list I was
only able to select 1 item and not several.

Ellen

"Dave Peterson" wrote:

Maybe you coud use Data|Validation.

Debra Dalgleish has lots of tips:
http://contextures.com/xlDataVal01.html



Ellen wrote:

Is it possible to create a list in excel 2003 and allow up to 6 items on the
list to be selected and have them displayed in the cell?


--

Dave Peterson


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default List to select up to 6 selected responses

Ellen

From Debra Dalgleish............

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 Fri, 11 May 2007 10:40:01 -0700, Ellen
wrote:

I looked at data validation. From what I could see, using Allow list I was
only able to select 1 item and not several.

Ellen

"Dave Peterson" wrote:

Maybe you coud use Data|Validation.

Debra Dalgleish has lots of tips:
http://contextures.com/xlDataVal01.html



Ellen wrote:

Is it possible to create a list in excel 2003 and allow up to 6 items on the
list to be selected and have them displayed in the cell?


--

Dave Peterson




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
sheet protection - only selected range to be able to select/input data Corey Excel Worksheet Functions 7 February 13th 07 05:41 PM
Give RELEVANT responses to questions. DO NOT give usless list pmartin Excel Worksheet Functions 2 July 6th 06 06:08 PM
A validated List which link to selected cells according to what is selected on the list WL Excel Worksheet Functions 1 June 5th 06 08:52 PM
Can you select a chart but not see it's selected? Mark Stephens Charts and Charting in Excel 1 May 8th 05 08:17 AM
How do I de-select a selected row? Suze Excel Discussion (Misc queries) 1 April 25th 05 05:10 PM


All times are GMT +1. The time now is 02:15 AM.

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

About Us

"It's about Microsoft Excel"