How do you make a....

[Akusuzaku]

Dropdown Menu, but then a program that imputs information when a certai
one from the dropdown menu is selected.

Making an order form that auto puts in information depending on whic
vender the user selects.

So, for instance. If the user selects "Wal-mart" ( I know bad exampl
lol), in the 5 empty cells below it fills out the address that
specify.

Thanks in advance :

 

[RagDyer]

Check out his site of Debra Dalgleish.

Scroll down to the D's, and read all the pages on "Data Validation", which
is probably the feature that you should use:

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

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[Debra Dalgleish]

You can use data validation, and vlookup formulas to do this. There are
instructions in Excel's Help, and here:

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

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

and instructions for an order form here:

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