userform problem

[cashmire]

Hello!
Could someone pleasehelp me..
I would like to create a userform that pastes a value (that the user types into the textbox in the userform) in a specified cell in a specified sheet.
Is that possible?
Thank you,
Cashmire

 

[Loomah]

Hi
Assuming you have a command button (CommandButton1) and a Text box (TextBox1) this will put whatever is in the text box into cell B2 of the second sheet of your book when you click the button

Private Sub CommandButton1_Click()
Worksheets(2).Range("B2") = Me.TextBox1.Value
End Sub

;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244

 

[PHV]

Simply set the ControlSource property of the TextBox to the destination cell address.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244