You may want to look at excel's built in version:
Data|Form (in xl2003 menus)
If that's not enough...
You could look at John Walkenbach's enhanced data form:
http://j-walk.com/ss/dataform/index.htm
The source code is available for a small fee ($20 USA, IIRC). So you can modify
it as much as you want.
=========
Or you could build your own from scratch. If you've never created a userform...
Debra Dalgleish has some nice notes about userforms:
http://contextures.com/xlUserForm01.html
(video:
http://contextures.com/xlVideos05.html#UserForm01)
and
http://contextures.com/xlUserForm02.html
Dobbin0_4 wrote:
I would like to enter data to a speadsheet with a userform.
I want enter the data in a form that will automatically insert the data to
the correct cells in my spreadsheet. And then allow me to enter new data on
the next line below.
Is this possible?
--
Dave Peterson