G
Guest
Can someone tell me how I can take the value a user would enter into a
textbox of a userform and place that value into a particular worksheet cell
(ie cell A1).
For instance, I have "userform1" displayed upon the activate event of the
worksheet.
The value a user inputs into "textbox1", which is on "userform1", I want to
be valued into cell A1.
There is also "commandbutton1" on the form and I was thinking the code to
value cell A1 was needed upon the click event of the button and before the
code to hide the userform.
Any and all help would be appreciated. Thank You
textbox of a userform and place that value into a particular worksheet cell
(ie cell A1).
For instance, I have "userform1" displayed upon the activate event of the
worksheet.
The value a user inputs into "textbox1", which is on "userform1", I want to
be valued into cell A1.
There is also "commandbutton1" on the form and I was thinking the code to
value cell A1 was needed upon the click event of the button and before the
code to hide the userform.
Any and all help would be appreciated. Thank You