Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
3-level Hierarchical dropdown lists in Excel - possible?
Desired action: Dropdown list 1 contains choices such as Ford, Chevy, VW,
etc. If user chooses Chevy, the cursor is automatically advanced to a second dropdown list with choices such as Corvette, Malibu, Suburban. If user chooses Malibu, the cursor is automatically advanced to a third dropdown list with choices such as blue, red, green, etc. If user executes an ALT-click (or ctrl-click, or shift-click, or whatever while positioned on any menu item at any level of either of the three lists, that selection item gets populated into the final, destination cell. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
3-level Hierarchical dropdown lists in Excel - possible?
Hi Rob,
Have a look at this site by Debra Dalgleish. http://www.contextures.com/xlDataVal13.html#Depend -- Regards, OssieMac "Rob Benz" wrote: Desired action: Dropdown list 1 contains choices such as Ford, Chevy, VW, etc. If user chooses Chevy, the cursor is automatically advanced to a second dropdown list with choices such as Corvette, Malibu, Suburban. If user chooses Malibu, the cursor is automatically advanced to a third dropdown list with choices such as blue, red, green, etc. If user executes an ALT-click (or ctrl-click, or shift-click, or whatever while positioned on any menu item at any level of either of the three lists, that selection item gets populated into the final, destination cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dropdown lists in Excel | Excel Worksheet Functions | |||
Excel 2003 - Customise a Data Form for dropdown lists | Excel Discussion (Misc queries) | |||
Excel 2002 dropdown lists | Excel Worksheet Functions | |||
IF/THAN with regards to 2 Dropdown Lists in Excel? | Excel Worksheet Functions | |||
Excel Spreadsheet - Formatting Dropdown lists | Excel Worksheet Functions |