Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multi-select from a dropdown list
I have a dropdown list but wish to select more than one item from it - is
this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multi-select from a dropdown list
Not really.
Could you replace it with a listbox -- and allow multiple selections? PaulaG wrote: I have a dropdown list but wish to select more than one item from it - is this possible? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multi-select from a dropdown list
Hi Paula
Only with code This code (not written by me) will allow you to make multiple selections from a data validation cell, and will insert a comma between each selected value Private Sub Worksheet_Change(ByVal Target As Range) Dim rngDV As Range Dim oldVal As String, newVal As String Dim tr As Long tr = Target.Row If Target.Count 1 Then GoTo exitHandler On Error Resume Next Set rngDV = Cells.SpecialCells(xlCellTypeAllValidation) On Error GoTo exitHandler If rngDV Is Nothing Then GoTo exitHandler If Intersect(Target, rngDV) Is Nothing Then 'do nothing Else Application.EnableEvents = False newVal = Target.Value Application.Undo oldVal = Target.Value Target.Value = newVal If oldVal = "" Then 'do nothing Else If newVal = "" Then 'do nothing Else Target.Value = oldVal _ & ", " & newVal End If End If End If exitHandler: Application.EnableEvents = True End Sub It is event code so you need to copy it to the sheet where you have your cells with Data Validation. Copy code above Right click on sheet tabView Code Paste code into white pane that appears Alt+F11 to return to Excel. -- Regards Roger Govier PaulaG wrote: I have a dropdown list but wish to select more than one item from it - is this possible? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multi-select from a dropdown list
Multiselect from a DV dropdown is possible using VBA.
See Debra Dalgleish's site for a downloadable sample workbook with event code. http://www.contextures.on.ca/excelfiles.html#DV0017 Note that you can have the selections in an adjacent cell or in the same cell. Gord Dibben MS Excel MVP On Wed, 7 Apr 2010 05:34:01 -0700, PaulaG wrote: I have a dropdown list but wish to select more than one item from it - is this possible? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multi-select from a dropdown list
http://boisgontierjacques.free.fr/fi...Successifs.xls JB http://boisgontierjacques.free.fr/ On 7 avr, 15:00, Dave Peterson wrote: Not really. Could you replace it with a listbox -- and allow multiple selections? PaulaG wrote: I have a dropdown list but wish to select more than one item from it - is this possible? -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multi-select from a dropdown list
I don't open unsolicited workbooks.
JB wrote: http://boisgontierjacques.free.fr/fi...Successifs.xls JB http://boisgontierjacques.free.fr/ On 7 avr, 15:00, Dave Peterson wrote: Not really. Could you replace it with a listbox -- and allow multiple selections? PaulaG wrote: I have a dropdown list but wish to select more than one item from it - is this possible? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi Select from Drop List | Excel Discussion (Misc queries) | |||
List Box - Multi Select Issue | Excel Worksheet Functions | |||
Multi-select from drop down list in Excel 97 | Excel Discussion (Misc queries) | |||
how do I select multi values from a list | Excel Discussion (Misc queries) | |||
List Box Multi Select Option | Excel Worksheet Functions |