| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to dynamically change the list in drop down list based on thevalue of another cell?
Hi all,
My question is that I have a drop down list containing, say 3 products (apple, orange, banana) in cells A1:A3. Usually I want the drop down list to list all 3 products. But when the value of cell B1 changes from 1 to 0, I want the drop down list to only list the first product contained in cell A1. Can this be done easily, without having to use VBA? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change drop down list in one cell based on values in other cells | Excel Discussion (Misc queries) | |||
| Excel 2003 - Drop Down list based on another cell value | Excel Discussion (Misc queries) | |||
| How do I change contents of a cell based on drop down list selecte | Excel Worksheet Functions | |||
| display a drop-down list based on the content of another cell | Excel Discussion (Misc queries) | |||
| Dynamically adding an in-cell drop-down list (i.e. Validation Object) to a cell? | Excel Programming | |||
Threaded Mode
