writing from inputbox to textbox

[bmacias]

Hi all,

For the life of me I can get this to work. It gives me and "object required" error on the second line. All I'm trying to do is get the name of the person who the fax will be sent to via an input box and paste the information unto a text box that resides on my worksheet.

Please help.

Sub angie()
Dim danny As String

danny = InputBox("Who is the fax for?", "titulo", "Alexis")
TextBox1.Value = danny

End Sub

 

[agihcam]

how about including your sheet name where your textbox is;

something like;

sheets("yoursheetnamehere").TextBox1.Value = danny

 

[bmacias]

Thank you. That did the trick!

 

[Smitty]

Try:

ActiveSheet.TextBox1.Value = danny

HTH,

Smitty