All I'm after doing is:-

From a click of a button

Copying in formation from a form in excel to a table in excel (same
workbook)

Clearing data in form (reset form to blank)

then next time the information is populated in to form it will add this to
the next line in the table

Cheers

hi
its not that hard. you would need 2 lines like the following for each
control on your form who's value you wish to store and reset.

Range("A65000").End(xlUp).Offset(1, 0).Value = TextBox1.Value
TextBox1.Value = ""

the first line moves the text box value to the sheet.
the second line clears the text box.

but just to point out, this type of form is built into excel.
in 2003, it's dataformfollow the wizard.
not sure where it is in 2007.
you may have to set up the table first so that the form can detect the data
but once done, it's easy after that. and it has scrollable capabilites.

regards
FSt1


"Stig - tame racing driver" wrote:

All I'm after doing is:-

From a click of a button

Copying in formation from a form in excel to a table in excel (same
workbook)

Clearing data in form (reset form to blank)

then next time the information is populated in to form it will add this to
the next line in the table

Cheers

cheers

"FSt1" wrote in message
...
hi
its not that hard. you would need 2 lines like the following for each
control on your form who's value you wish to store and reset.

Range("A65000").End(xlUp).Offset(1, 0).Value = TextBox1.Value
TextBox1.Value = ""

the first line moves the text box value to the sheet.
the second line clears the text box.

but just to point out, this type of form is built into excel.
in 2003, it's dataformfollow the wizard.
not sure where it is in 2007.
you may have to set up the table first so that the form can detect the
data
but once done, it's easy after that. and it has scrollable capabilites.

regards
FSt1


"Stig - tame racing driver" wrote:

All I'm after doing is:-

From a click of a button

Copying in formation from a form in excel to a table in excel (same
workbook)

Clearing data in form (reset form to blank)

then next time the information is populated in to form it will add this
to
the next line in the table

Cheers