Hi Does someone know how to when in VBA, when typing into a user input form, you then press the relevant command button on the form, say 'update' and then that information just entered into teh form will ome up on a row in an excel spreadsheet and then the problem is that how do you code it so that when the data, you've just entered goes into the top row, how will you you go about going straight onto the second row and so forth. I got this bit of code, but is thee a bit more that goes with it: ActiveCell.Offset(1, 0).Select Thanks

There are many ways to do this. You first have to initialize the first cell The following works but can be broken if one clicks on a cell making the active cell move to that point. ------------------------ Public INIT As Boolean ' Private Sub UpdateButton_Click() If INIT = False Then Range("A1").Select INIT = True End If ActiveCell.Value = TextBox1.Text RowOffset = 1 ColumnOffset = 0 ActiveCell.Offset(RowOffset, ColumnOffset).Activate End Sub ============================================= Another way to do this that can't be broken by activating another cell is -------- Public INIT As Boolean Public Row As Integer ' Private Sub UpdateButton_Click() If INIT = False Then Row = 1 INIT = True End If Column = 1 Cells(Row, Column).Value = TextBox1.Text Row = Row + 1 End Sub

Thanks for the help, its actually working now.