drop down boxes

judygal · Mar 25th, 2002, 03:52 AM

Hi everyone. I am having trouble getting drop down boxes to work in Excel 97. What I want to do is when someone clicks or arrows into a certain cell, have a drop down box appear for them to choose one of the items. I have tried doing it with the form toolbar, but can't seem to get that to work, tried it with data validation, which will work until I close and reopen, then it disappears. Can anyone help. Please.

Dave Hawley · Mar 25th, 2002, 04:01 AM

Hi judygal

You say that once you close and re-open, the Validation list is gone. I have to ask 2 obvious questions.

1. Are you saving?
2. Do you click back in the cell with the Valdidation?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 25th, 2002, 03:52 AM	#1
judygal New Member Join Date: Mar 2002 Posts: 1	Hi everyone. I am having trouble getting drop down boxes to work in Excel 97. What I want to do is when someone clicks or arrows into a certain cell, have a drop down box appear for them to choose one of the items. I have tried doing it with the form toolbar, but can't seem to get that to work, tried it with data validation, which will work until I close and reopen, then it disappears. Can anyone help. Please.

Mar 25th, 2002, 04:01 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi judygal You say that once you close and re-open, the Validation list is gone. I have to ask 2 obvious questions. 1. Are you saving? 2. Do you click back in the cell with the Valdidation?