Solved: Add new row to spreadsheet

[bopo]

Hi people

Right basically each time a user does a certain process, I want information within several text boxes to be stored within a spreadsheet permentely, however I want to be excel to use a new row per process, therefore not overwriting the previous record, how do I do this?
also the information is coming for several UserForms

[Bob Phillips]

[vba]

iLastRow = Cells(Rows.Count,"A").End(xlUp).Row + 1
Range("A" & iLastRow).Value = textbox1.Text
'etc.
[/vba]

[bopo]

[vba]

iLastRow = Cells(Rows.Count,"A").End(xlUp).Row + 1
Range("A" & iLastRow).Value = textbox1.Text
'etc.
[/vba]

Thanks, however how do I specify which worksheet I want to write to?

as this coding is going behind a button on a userform

[Bob Phillips]

Thanks, however how do I specify which worksheet I want to write to?

as this coding is going behind a button on a userform

[vba]

With Worksheets("Sheet1")
iLastRow = .Cells(.Rows.Count,"A").End(xlUp).Row + 1
.Range("A" & iLastRow).Value = Textbox1.Text
'etc.
End With
[/vba]

[bopo]

thanks

[Bob Phillips]

If you have Option Explicit, iLastRow must be explicitly declared

[vba]

Dim iLastRow As Long

'rest of code
[/vba]