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 cellPosted 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.
Re: Link text in text box to value in a cellPosted by JAF on October 05, 2000 8:48 AM
The trick is to select the text box before specifying the value as follows:
ActiveSheet.Shapes("Text Box 1").Select
Selection.Characters.Text = Range("B3").Value
HTH - JAF
Re: Link text in text box to value in a cellPosted 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 cellPosted 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.
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.