| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select multiple names from drop down list | Excel Worksheet Functions | |||
| with a drop down list in excel how do I select multiple values | Excel Discussion (Misc queries) | |||
| how do i choose multiple options in a drop down menu in excel? | Excel Discussion (Misc queries) | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
| How do I set up a drop down box in Excel with a list of options f. | Excel Discussion (Misc queries) | |||
Threaded Mode
