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.
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
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.
Ivan
