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
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Wrapping and Anchors 0
Content Control Box Issue - Please Help! 0
Excel - Wich Function should I use? 1
Can UDF return a customized hyperlink? 3
Link a text box based on drop down box with four options MS Word 365 0
IF AND Function Date Range Issues 6
can a cell be both input and output? 3
VB code. If statement between two values 1

Top