sorry if this has already been asked before but i just need to know how to
create two drop down menus, where if a selection is made in the first drop
down affects the contents in the second drop down.

for example, if fruit is selected in the first drop down then the contents
of the second drop down will be Apple, if vegetables is selected then lettuce
will show.

Dropdown 1
Fruit
Vegetables

Dropdown 2
Apple
Lettuce

Hope this makes sense

Thank you!

Hi Loolin,

See Debra Dalgleish's page on dependent lists at:

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

Also see xlDynamic's page on dependent dropdowns at:

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


---
Regards,
Norman



"leolin" wrote in message
...
sorry if this has already been asked before but i just need to know how to
create two drop down menus, where if a selection is made in the first drop
down affects the contents in the second drop down.

for example, if fruit is selected in the first drop down then the contents
of the second drop down will be Apple, if vegetables is selected then
lettuce
will show.

Dropdown 1
Fruit
Vegetables

Dropdown 2
Apple
Lettuce

Hope this makes sense

Thank you!