| 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,
You can do this with named ranges. For example, you could name the full list (A1:A3) "Full" and name the shorter list (cell A1) "Short". Then put this formula in the data validation formula bar: =if($B$1=0, Short, Full). Ben |
| Reply |
| 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 | |||
Hybrid Mode
