Multi layered drop down

R

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make items in a drop down menu reference a number 2
Creating drop downs in a cell contingent on another drop down 1
Drop-down list problem 2
Drop down list 2
Create Drop Down Box populated by a List 1
Drop Down Problems 2
Drop Down Default 1
Show drop down icon 3

Top