Drop down box
Posted by Jay on January 16, 2002 9:42 PM
I need to create a drop down box that will when clicked on will have choices when one is chosen will return several values to the active cell the list box is located. What I am choosing from is a simple list with four colomns.
Name Type Color Cost
Charlotte Rose Red 1.50
Gerbera Daisey Pink 2.50
Can I just choose one name and the other three columns will be chosen also? Or do they need to be linked together. Help Jay