Is there a way to set up a user form, or something similar, so that when I
click a button, it will bring up a place for a person to type small bits of
information. When they are done and submit the info, it will go to a specific
cell in the worksheet?

For example,
I want to add a City to a list. I click the add city button. Type in the
city and click OK. The city will then be added to a list?

Any help or ideas is always appreciated.

Thanks,
Steve