Userform / textbox data to sheet example request.

[dbmathis]

Hi all,

I have created a userform (transEntry) and I am seeking an example of taking the data that has been entered into a textbox on the userform and copying it into a cell on my sheet.

The Submit button on the userforn is: CommandButton1
An example text box is: TextBox2

What I am hoping I can get to happen is there will be text in TextBox2 and when someone clicks the Submit button (CommandButton1), the text in TextBox2 is copied to some cell on my sheet1 (Ex: M17).

Then after the submit button has been pushed and the data copied, then the userform (transEntry) is cleared out.

Would someone mind creating an example for me?

Thanks

 

[Norie]

Something like this perhaps.

Private Sub CommandButton1_Click()
    Range("M17").Value = Textbox2.Text
    Textbox2.Text = ""
End Sub

 

[dbmathis]

Cool, thanks Norie.

 

[dbmathis]

This question is related to this thread so I will ask it here.

Consider that there is a column of data, I2 thru I212, and cells I2 thru I100 contain data.

Rather than posting the data for Textbox2 into a static cell like M17. How would I modify Norie's VBA to start in cell I212 and search upward until a cell with data in it's found (in this example: I100) and then paste the data that's in Textbox2 six cell to the left of it (which would be in this example C100)?

 

[dbmathis]

Anyone?