Sending text from a Text box to a sheet

M

morry

I have a form with a text box and a command button on it. I have
a button on the worksheet that makes this form pop up. I want to b
able to type text into the box and send it (by hitting the comman
button) to a different sheet in the same workbook and place it in
specific cell.

If someone could help me with this that would be great.

Thanks
Morr
 
C

Chip Pearson

Morry,

In the Click event of the command button, use code like

Worksheets("Sheet2").Range("A1").Value = _
Me.TextBox1.Text


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
M

morry

Thanks Chip that works.
But now I'm having trouble hiding the form. The code I put in is:
Form.hide

but it tells me: Must close or hide topmost modal form first
I only have one form and the only code in it is the code you gave me.
I have a button on Sheet1 that has the code: Form.Show but i don't kno
what it wants me to close.

Any Suggestion?

Thank you
Morr
 
C

Charles

morry said:
Thanks Chip that works.
But now I'm having trouble hiding the form. The code I put in is:
Form.hide

but it tells me: Must close or hide topmost modal form first
I only have one form and the only code in it is the code you gave me.
I have a button on Sheet1 that has the code: Form.Show but i don't know
what it wants me to close.

Any Suggestion?

Thank you
Morry
Click to expand...

Try using the command Unload Userform1 instead of Form.hide

HTH
Charles
 
T

Tom Ogilvy

Try using

Me.hide

if the instruction is in the code associated with the userform.
 
Top