Function in TextBo

  • Thread starter Thread starter KC
  • Start date Start date
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
 
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)
 
You must log in or register to reply here.

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

Can UDF return a customized hyperlink? 3
SUMIF "value if false" not working 2
validate date entered 3
SUMIF with criteria "<>" & "=" 4
using text as a "true" condition in an if function. 4
can a cell be both input and output? 2
Finding values in different rows/columns 1
Convert a text in a date format 2

Back
Top