Text box

[Greg Brow]

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

 

[Harald Staff]

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]

Thanks it works great.

Greg

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