Home |
Search |
Today's Posts |
#1
|
|||
|
|||
INDIRECT function question
I am using XL 2002 on an XP pro box.
I have an applciation that extensively uses Validation Lists. Here is what I would like to do: In cell A1, I have the Validation list set to v_A1_List. In cell A2, I have a Validation list set to either v_A2_List1 or v_A2_List2, depending on the value chosen in cell A1. I'm pretty sure that this is possible using the INDIRECT worksheet function. I'm just not sure how to implement it. BTW, I also need to use worksheet fundtions to do this. Right now, VBA is not a via alternative. Any ideas would be greatly appreciated. TIA, -- Joe VBA Automation/VB/C++/Web and DB development |
#2
|
|||
|
|||
See
http://contextures.com/xlDataVal02.html In article , Joe wrote: I am using XL 2002 on an XP pro box. I have an applciation that extensively uses Validation Lists. Here is what I would like to do: In cell A1, I have the Validation list set to v_A1_List. In cell A2, I have a Validation list set to either v_A2_List1 or v_A2_List2, depending on the value chosen in cell A1. I'm pretty sure that this is possible using the INDIRECT worksheet function. I'm just not sure how to implement it. BTW, I also need to use worksheet fundtions to do this. Right now, VBA is not a via alternative. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indirect( ) function loosing values when spreadsheets are closed | Excel Worksheet Functions | |||
Function question | New Users to Excel | |||
Function question | Excel Worksheet Functions | |||
Grading Function Question... | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |