I speak as someone new to VBA, and would be grateful for any help for the
following:

I have a sheet in Excel set up to hold contact info, e.g. Name, Surname,
Address, Telephone etc...
The idea is that in order to enter a new contact, the data is entered onto a
simple form, with textboxes for the appropriate fields.

What I am stuggling with is once the data has been entered on this form and
okayed, how can I then work things such that the entries in each field are
then entered onto the corrosponding fields on the worksheet?

Is this supposed to be done by worksheet objects? If so, a simple guide or
website would be much appreciated.
If I am completely wrong then please correct me!

Regards,
Baz.

You haven't indicated wether multiple people will need to
add information or whether this is to simplify data entry
for a single person. I'll attempt to answer both.

1) If single person doing data entry then Excel already
has a built in form. You need to set up all the column
headings in one row. Select a cell within the row and
select Tools-Data-Form. You can add, delete or scroll
through the information in this way.

2) If multiple people, there are many ways to do this,
here are two easy ones:
-Excel-Use template wizard with data tracking. Essentially
you create an Excel template which users use to fill in
the data. Cells within this template are linked to a
central Excel spreadsheet set up as above (Column headings
in one row, one record per row following). Template wizard
with data tracking is not installed as a default so you
may need to add it (Tools-Addin). Start the wizard and
follow the on screen instructions.

-Word-Create a form (see other post). Have the user fill
in the form. Then you have two choices, have the user do a
Tools-Options-Save and check the "Save Data Only for
forms". When they save the document it will create a file
with the data in comma sepreated values which can then be
imported to Excel. The other option is to create an
AutoClose macro to do the same.

Good luck
Marc