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.