Link to home
Start Free TrialLog in
Avatar of tiehaze
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.
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tiehaze
tiehaze

ASKER

Thanks!
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