Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating dependent list boxes
I have a table containing product part numbers. Each of these part
numbers is available with up to three (3) separate accessories. Some products are available with all three accessories while others may only be available with two of the three or even one of the three accessories. What I want to do is this: When the user selects a particular part number in a drop down list in lets say cell A1, I want cell A2 to display a drop down list containing only those accessories available for the selected part number. Example: Cell A1 = Part #123 Cell A2 = drop down displays accessories A, B & C Cell A1 = Part #555 Cell A2 = drop down list displays accessory A only Any help with this would be greatly appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dependent drop-down boxes | Excel Worksheet Functions | |||
How do I create 3 list boxes dependent on prior selections | Excel Discussion (Misc queries) | |||
Dependent Drop Down Boxes | Excel Worksheet Functions | |||
dependent dropdown boxes | Excel Worksheet Functions | |||
Creating Drop Down boxes with the List function... | Excel Discussion (Misc queries) |