I am building a couple of surveys that ask questions and let you chose things like Usually (=1) Often (=2) Sometimes (=3) Occassionally (=4) Rarely (=5) Never (=6) ... you get the idea.

I have been experimenting with the worksheet function dget, and using validation to get a dropdown box (but I am new at this advanced stuff, although I have been using excel for a long time).

How can I make a pull down menu so people can use a pull down menu to choose the words, but when they select it, a number is loaded someplace so I can run the numbers? I know exactly how to do this in Access...

Thanks in advance.