How do I output a text box to a cell?

[Tibbs]

I'd like to take the contents of a text box in excel and output it to a cell. I just can't figure out how to do it. Is there a formula way of doing it, or will I have to use VBA?

I've named the text box Product_Name, if that helps...

Many thanks,

Chris

[sweep]

Please Login or Register  to view this content.

Will copy the contents of your text box to the currently active cell.

hth
Dave

[davesexcel]

Private Sub Product_Name_Change()
Range("A1") = Product_Name
End Sub

[jasoncw]

Is this text box from the Pictures toolbar, Forms toolbar, or Controls toolbar? If it's not from the Pictures toolbar, you can simply go into properties and input the cell address in the Linked Cell property.

HTH

Jason

[Tibbs]

Thank you all for your replies.

I went with Jason's solution in the end. There isn't a Linked cell option on the format control right click menu like there is on combo boxes and the like, but there is one in the properties section of the right click menu.

Thanks again!

Chris