tiehaze
asked on
Excel, conditional drop down boxes
I need to have conditional drop down box. Here is a simplified example:
In Cell A1 I want a drop down box to have two options ("X" and "Y"). If "X" is selected, in cell B1 I want a drop down box with all of the column headers in "Sheet2". If "Y" is selected, in cell B1, all I want is for the user to be able to enter in text.
If I can clear anything up for you, let me know.
In Cell A1 I want a drop down box to have two options ("X" and "Y"). If "X" is selected, in cell B1 I want a drop down box with all of the column headers in "Sheet2". If "Y" is selected, in cell B1, all I want is for the user to be able to enter in text.
If I can clear anything up for you, let me know.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I uploaded a solution to https://filedb.experts-exchange.com/incoming/ee-stuff/3286-20070427---Dependent-selection-.zip - it involves a few macros in the vba code for sheet1 and you also need to define all your columns in sheet to to a named range called "columns".
Hope it helps
Andi
Hope it helps
Andi
ASKER