Excel - complicated drop down boxes

  Chris123 09:23 10 Jul 2003

Please can anybody help - Windows XP and Office XP.

I would like to prepare a spread sheet containing a number of related drop down boxes.

Clicking on the first box (cell A1) gives a list of Options - Option1, Option2 and Options3 etc.

When we click on option 1, I would like it to bring up another list of Options, say ABC and D in another cell (cell B1)

If we clicked on Option 2, I would like cell B1 to bring up a different range of Option, say WXY and Z

And so on! Many thanks in advance.

  VoG II 09:58 10 Jul 2003

Create your first List Box. Right click it and select Format control. In Input range specify A7-A9 and in Cell link select A6.

In A7:A9 write Option 1, Option 2, Option 3.

In D7-D15 (or however many you need) enter your second lot of possibilities A, B, C, D...I

In E7 enter the formula


and copy down to E8 and E9.

Build your second form and set its Input range to E7 to E9.

You may wish to change the actual cell addresses used - the above is just an illustration of how this can be done.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best Amazon Echo: What’s the best Alexa speaker?

Kano Computer Kit Complete review: A fun DIY 'laptop' that teaches kids to code

Best pro photo editors for Mac 2018

TV & streaming : comment regarder les Jeux olympiques d’hiver 2018 ?