dbmathis
Well-known Member
- Joined
- Sep 22, 2002
- Messages
- 1,064
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
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