Inputbox

[Rick Sanderson]

Hi,
I have designed a form which has textboxes on it for inputting data,
how do i get the data into a cell?

ie text from account textbox into A1
text from reference textbox into A2

Thanks,
Rick

 

[Dave Peterson]

I put a textbox and a commandbutton on a userform and had this code under the
button:

Option Explicit
Private Sub CommandButton1_Click()
Worksheets("sheet1").Range("a1").Value = Me.TextBox1.Value
End Sub

 

[Rick Sanderson]

Thanks Dave