Self Populating Lists - Form Controls

[Rob2101]

Hi There,

Is it possible to create lists using the form controls under the developer tab (similar to that of Data Validation, using the indirect formula to look at selected options)?

E.g.

First List: States
Second List: Regions, populate from selected state in first list.

Regards,
Rob

[john55]

hi,
Bob has a very nice example, hope it helps you!
http://www.xldynamic.com/source/xld.Dropdowns.html