Try selecting your range then hitting Data|Form.

If you need more, you may want to look at John Walkenbach's enhanced dataform:
http://j-walk.com/ss/dataform/index.htm
may be sufficient

And if you want to create your own, then Debra Dalgleish has a get started with
userforms:
http://contextures.com/xlUserForm01.html

GaryC wrote:

Hi Everyone,
This is my dilemma. I am looking for a way to create a data input box that
will put data into a spreadsheet one entry at a time and then drop down a
cell. I want to put the information into a spreadsheet in a uniform fashion.

--

Dave Peterson