is it possible for a drop down menu to select other drop down men

[swain.s]

i am trying to set up drop down menu to select other drop down menus ie :-
main drop down=alpha, numeric,roman, sub drop down menu's (a,b,c etc),(1,2,3
etc), (I,II,III etc)

 

[Gary Keramidas]

maybe debra's site will help


http://www.contextures.com/xlDataVal02.html

 

[Norman Jones]

Hi S,

See Debra Dalgleish at

Excel -- Data Validation -- _
Dependent Dropdowns from a Sorted List
http://www.contextures.com/xlDataVal13.html

See also xlDynamic at:

Dynamic Dependent Dropdowns
http://www.xldynamic.com/source/xld.Dropdowns.html