Hi greg

Try something like

Private Sub CommandButton1_Click()
Dim R As Long
R = 15 'or whatever desired row variable
Sheets(1).Cells(R, 1).Value = TextBox1.Text
End Sub


HTH. best wishes Harald

"Greg Brow" skrev i melding
...
Hi sorry to bother,

I have a userform which I have created and I would like to transfer the
information that i put in to textbox1 and copy this information onto a
speadsheet called (template) I have set up. I have worked all other
things
out at this stage but when i try to use the code i put it actually copies
the code and pastes that onto the spread sheet


Thanks in advance

Greg