View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default Multi layered drop down

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 he
http://www.ozgrid.com/VBA/custom-menus.htm


"rexmann" wrote:

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