Storing data in VBA into one single row in worksheet using userforms

[VBAmalta89]

I have a user form where I need the user to input some data which will be stored in one row after which the user will exit the form. When new data is to be added (using the userform again) it must be added on the next row.

How can i do this? I am new to VBA programming so I would appreciate your help.

Thanks!

 

[VoG]

There is example code here http://www.contextures.com/xlUserForm01.html

 

[VBAmalta89]

i had a look at that but I couldnt understand this line of code:

irow = ws.Cells(Rows.Count, 1) _
.End(xlUp).Offset(1, 0).Row

How can I specify in the coding where to look for the empty row where data is to be added?

 

[VoG]

Which column do you want to add data to?

 

[VBAmalta89]

what i mean is that how can i specify that for example i want it to start inserting data from row 3 in column C then the next entries are in row 4

 

[VoG]

Try like this

Range("C" & Rows.Count).End(xlUp).Offset(1).Value = TextBox1.Value

 

[VBAmalta89]

thanks a real lot it worked perfectly for me!!