Multi layered drop down

[rexmann]

Hi

I am trying to create a multi layered drop down a bit like the Windows Start
menu. Therefore
you have a drop down menu a,b,c and d. If you select one of these options
you then
are given another drop down list. The option you select in the final drop
down then appears
in the cell.

Is this possible to do? Any help greatly appreciated

Kind regards

rexmann
ps using Excel 2007

 

[JLatham]

This all depends on where you want your lists.

Basically you can't do it on a worksheet with the tools microsoft has
provided, but you can develop several drop-down lists each of which is
dependent on the choice made in another:
http://www.contextures.com/xlDataVal13.html and also check out this page
http://www.contextures.com/xlDataVal15.html

If you're looking to add another pre-Excel 2007 style menu entry, you can do
that through VBA programming. There's some good code to follow here:
http://www.ozgrid.com/VBA/custom-menus.htm