Yes I am still using Excel 97!
I just want to make a spread sheet with about 10 drop downs that I can select text from. It's sort of a "shopping List" that will be printed when filled out.
First tab will have the drop down boxes and the second tab will have all the data.
I spent some time on google trying to find how to do it in 97 and didn't get anywhere. I can do it with VBA but I think this way is much easier.
Thanks for any Help
Menessis
I just want to make a spread sheet with about 10 drop downs that I can select text from. It's sort of a "shopping List" that will be printed when filled out.
First tab will have the drop down boxes and the second tab will have all the data.
I spent some time on google trying to find how to do it in 97 and didn't get anywhere. I can do it with VBA but I think this way is much easier.
Thanks for any Help
Menessis