Function in TextBo
 

How do I return a value (cell A1) in a text box?

I thought it was as simple as entering =A1 in the Text Box,
but =A1 seems to be treated as a text when I enter it.

Tks, Kaye

Kaye

If this is a textbox from the controls toolbox (ActiveX) then set the
LinkedCell property to $A$1

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"KC" wrote in message
...
How do I return a value (cell A1) in a text box?

I thought it was as simple as entering =A1 in the Text Box,
but =A1 seems to be treated as a text when I enter it.

Tks, Kaye

Thanks Nick!
Kaye

On Sun, 30 Jan 2005 22:54:30 -0000, "Nick Hodge"
wrote:

Kaye

If this is a textbox from the controls toolbox (ActiveX) then set the
LinkedCell property to $A$1