Function in TextBo

K

KC

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
 
N

Nick Hodge

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
[email protected]
 
Top