How can I select multiple options in an Excel 2003 drop down list
 

I have set up a drop down list. I would like to be able to select multiple
options from the list. I know I have seen it done for surveys and such, but
I have been unable to find help in setting it up.

How can I select multiple options in an Excel 2003 drop down list
 

Have you thought about replacing your dropdown with a listbox that allows
multiple selections?

tsmith wrote:

I have set up a drop down list. I would like to be able to select multiple
options from the list. I know I have seen it done for surveys and such, but
I have been unable to find help in setting it up.

--

Dave Peterson

How can I select multiple options in an Excel 2003 drop down l
 

1. By default all cells are locked; you have to unlock those cells you want
changeable:
Format, Cell, Protection, Unlock
Then you have to protect the sheet:
Tools, Protection, Protect
(I think macros, which you have to use to unhide rows, cant run in xl2007
if the sheet is protected. If you use 2007, use an alternate way; a macro.)
2. Date, Validation, Allow, List, Source, and enter Self Install,Sytem
integrator
3. Right-click worksheet tab, View Code, and paste this:

Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
If Target.Address = Range("C63").Address Then
If Target = "Systems Integrator" Then Rows("64:74").EntireRow.Hidden =
False
If Target = "Self Install" Then Rows("64:74").EntireRow.Hidden = True
End If
End Sub


"Dave Peterson" wrote:

Have you thought about replacing your dropdown with a listbox that allows
multiple selections?

tsmith wrote:

I have set up a drop down list. I would like to be able to select multiple
options from the list. I know I have seen it done for surveys and such, but
I have been unable to find help in setting it up.

--

Dave Peterson

How can I select multiple options in an Excel 2003 drop down l
 

Sorry. Worng place

"Tevuna" wrote:

1. By default all cells are locked; you have to unlock those cells you want
changeable:
Format, Cell, Protection, Unlock
Then you have to protect the sheet:
Tools, Protection, Protect
(I think macros, which you have to use to unhide rows, cant run in xl2007
if the sheet is protected. If you use 2007, use an alternate way; a macro.)
2. Date, Validation, Allow, List, Source, and enter Self Install,Sytem
integrator
3. Right-click worksheet tab, View Code, and paste this:

Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
If Target.Address = Range("C63").Address Then
If Target = "Systems Integrator" Then Rows("64:74").EntireRow.Hidden =
False
If Target = "Self Install" Then Rows("64:74").EntireRow.Hidden = True
End If
End Sub


"Dave Peterson" wrote:

Have you thought about replacing your dropdown with a listbox that allows
multiple selections?

tsmith wrote:

I have set up a drop down list. I would like to be able to select multiple
options from the list. I know I have seen it done for surveys and such, but
I have been unable to find help in setting it up.

--

Dave Peterson