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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Have you thought about replacing your dropdown with a listbox that allows
multiple selections?
 
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, can’t 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
 
Sorry. Worng place

Tevuna said:
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, can’t 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
Click to expand...
 
Back
Top