Add Drop Down Box in Excel 97

Menessis2

New Member
Joined
Dec 9, 2018
Messages
26
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
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Hello,

Are you thinking about adding ActiveX objects or Forms objects ...?
 
Upvote 0
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.
 
Upvote 0
Hi,

If it is a One Time Only task ... you are right ... you are better off doing it manually ... :smile:
 
Last edited:
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,184
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top