Formula in Textbox

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Is it possible to place a formule into a textbox? The
purpose is that I can link a cell with a textbox, so that
if I change the cell, also the textbox changes. Thanks in
advance.
 
Is it possible to place a formule into a textbox?

Sure. Select the text box then click in the formula bar and type your
formula.
 
Hi Tim,
I am not an MVP like Jim but I cannot get his suggestion to work with
anything other than simple cell references. If I select the textbox and in
the Formula Bar enter =A1 all is well. If I try =SQRT(A1), Excel complains
'not a valid cell reference or name'. SO it seems your formula must be in a
cell which the textbox references.
Bernard
 
Back
Top