user defined selection box

[nicody]

Is there a way to have an initial choice open a second choice etc...and at the end the final choice is populated into the original cell.

ex -my first cell A2 is under ITEM...in that cell I want to choose a PRODUCT...then VENDOR NAME...then MODEL #...then MODEL NAME.

Choices for Vendor name, model number and model name will need to be based on dependent lists related to previous selections.

In the end I want cell A2 to read "LIGHT SOURCE, LIGHTS ARE US, AM23456-001, LED SUPRA".

Is there a way to accomplish this with dropdown menus or form controls?

Thanks in advance for your help.

[davesexcel]

You may be referring to Dependent Comboboxes(dropdown) boxes.

See here for more info on that.

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