Excel Macros: Linking a textbox drawing object to a cell

[crackjack]

Can I link a textbox to a cell do that the textbox always displays the value in the cell...like writing a formula in the textbox or something? Would be better still if it also reflects the format of the cell, but that's dispensable.

Please help!

 

[BrianB]

select the textbox as if to enter text
Click in *formula bar* and enter a formula in the normal way.
eg. =A1

 

[crackjack]

select the textbox as if to enter text
Click in *formula bar* and enter a formula in the normal way.
eg. =A1

Thanks, but can I do it using Macros?

 

[jim may]

Sub Macro3()
'
' Macro3 Macro
' Macro recorded 7/27/2007 by Jim May
'

'
ActiveSheet.Shapes("Text Box 1").Select
Selection.Formula = "$A$13"
ActiveCell.Select

End Sub

 

[crackjack]

Sub Macro3()
ActiveSheet.Shapes("Text Box 1").Select
Selection.Formula = "$A$13"
ActiveCell.Select
End Sub

Thanks! Great! It works.

Strange though that Excel won't let me say

    ActiveSheet.Shapes("Text Box 1").Formula = "$A$13"

but works fine when I say

    ActiveSheet.Shapes("Text Box 1").Select
    Selection.Formula = "$A$13"

 

[jim may]

oh well,,
thanks for the feedback..

Jim May