MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Drop Down List


Posted by philipsmith on December 09, 2001 8:43 AM

How do you cause the choice of just ONE specific product from a product list of ten products, created by Data Validation, to open another drop down list on the adjacent cell in the row or perhaps any other specific cell? Can it be done without the use of VBA?


Posted by jack on December 09, 2001 9:15 AM

I gueass one selection in a drop down can trigger another, but function ONLY return values as answers, so wont trigger events as you ask, thus VBA only way, but complex and beyond me, ive had same idea but, on second selection caused problems, i still had to choose, so gave up.

sorry HTH

Second though if will cover second choice depending on first!