Userform textbox to excel sheet

[wonderd]

Hello all. I have a userform with a textbox (TextBox1) I would like to make it so the values from textbox1 come from sheet2 cell A1 OR if I enter values directly into the textbox they show on cell A1

[Trebor76]

Hi wonderd,

I have a userform with a textbox (TextBox1) I would like to make it so the values from textbox1 come from sheet2 cell A1

Try this:

Please Login or Register  to view this content.

OR if I enter values directly into the textbox they show on cell A1

Use this as the source code for a command button on your form which is just the opposite of the first piece of code:

Please Login or Register  to view this content.

HTH

Robert

[wonderd]

I have tried the first piece of code and it did not work. I would like it to automatically be done without a command button if possible. I entered values into the textbox but I do not see it show on sheet2

On my useform there is no "Private Sub UserForm_Initialize()" So I added it. I only had _Activate and _Click private subs

Please Login or Register  to view this content.

[wonderd]

bump, Anyone?

[romperstomper]

Cross-post: http://www.mrexcel.com/forum/excel-q...-userform.html