Creating a userform?

  • Thread starter Thread starter Dobbin0_4
  • Start date Start date
D

Dobbin0_4

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?
 
I have just put up a file for you at:-

http://www.pierrefondes.com/

It is item number 42 towards the top of my home page.

In here I have tried to explain, as clearly as possible, what you need to do
to set up and use a Form in EXCEL 2007. There is a simple worked example for
you to work through if you want to.

Please do not hesitate to ask further questions if the explanation that I
have provided is not clear.

Please hit Yes if my comments have helped.

Thanks.
 
Sorry, small error; any record that you add wil get added at row 11 (I used
row 10 to test it). Apologies.
 
Apologies once again. Thought your psoting was in General section not
Programming.
 
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
 
Back
Top