Add Drop Down Box in Excel 97

[Menessis2]

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

 

[James006]

Hello,

Are you thinking about adding ActiveX objects or Forms objects ...?

 

[Menessis2]

Hi James.....i can do it using forms with vb, but im just assuming that it would be easier to add the drop downs right in the first tab rather than doing all the code.

 

[James006]

Hi,

If it is a One Time Only task ... you are right ... you are better off doing it manually ...

 

[Menessis2]

The drop downs will have part numbers, supplier names and such. Foreman goes through makes selections, prints it and hands it to the person who will be doing the work. Then it needs to be reset for the next time.

 

[RoryA]

IIRC 97 had data validation dropdowns, but you'll need to name the data ranges on the second sheet to be able to refer to them in the data validation settings.

 

[Menessis2]

I was tinkering with that but couldnt figure out how it works. Or not even knowing if it would work for what I want. I will go back and try some more.

Thanks
Menessis

 

[Menessis2]

OK figured it out......
Use the "View", "Toolbars", "Forms" to add it to the worksheet