MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Link text in text box to value in a cell

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


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.

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


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
End Sub


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.

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.