Archive of Mr Excel Message Board


Back to Controls in Excel archive index
Back to archive home

Link text in text box to value in a cell

Posted by Zif on October 05, 2000 6:23 AM
Hiya

Is it possible to create a text box, in which the text that appears is linked to the value in another cell?

What I need is that when the cell value changes, the text in the text box changes as well.


Re: Link text in text box to value in a cell

Posted by JAF on October 05, 2000 8:48 AM
Zif

The trick is to select the text box before specifying the value as follows:

Sub SetTextBoxValue()
ActiveSheet.Shapes("Text Box 1").Select
Selection.Characters.Text = Range("B3").Value
Range("A1").Select
End Sub

HTH - JAF


Re: Link text in text box to value in a cell

Posted by AB on October 05, 2000 9:22 AM
If you just want to link the textbox to a cell then all you have to do is...

With the textbox selected enter: =Sheet1!A1
or just: =A1
in the formula toolbar.

This will link the textbox to whatever is entered in cell A1.


Re: Link text in text box to value in a cell

Posted by Ivan Moala on October 06, 2000 3:45 AM


Note: As well as the other suggestions you could also
use the "Camera" tool avail via Tools / Customize / format
then look for camera.....this is a handy tool for
taking copies of cells and linking.


Ivan


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.