Simon Lloyd;408235 Wrote:
Firstly i used checkbox1..etc as an example, you didn't say what the
boxes were, if you have used optMale etc then use those (as long as they
are checkboxes), you have used x in your range, i explained that x would
be your next location so you probably want
Code:
--------------------
Range ws.Cells(iRow, 5).Value
--------------------
but without seeing your workbook or structure i couldn't give you a
definite answer.

Hi again Simon

I have attached the excel file for you (Or anyone else who can help)
to have a look at if you have the time.

I am trying to allow users to fill in the form and then press enter,
which adds that record on to the row under the headings. The form
clears and users can add a new record, which will enter on the next
line down.

Sorry to be a pain everyone just trying to learn :o:

Kindest Regards

Kevin


+-------------------------------------------------------------------+
|Filename: Example user form.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=173|
+-------------------------------------------------------------------+

--
levtweeney
------------------------------------------------------------------------
levtweeney's Profile: http://www.thecodecage.com/forumz/member.php?userid=478
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113703