Display result in a text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all

is there a way to display a formula result in a text box of a sheet, where I can insert some explanetory note too

thank yo
Andrea
 
Hi Andrea
maybe the comment function is an alternative for you. Just select the
cell with your result and goto 'Insert - Comment'
 
See Frank's reply.

Or ... I don't know if you can do this directly, but if your formula is in
A1, then something like

="The answer is "&(A1)

in B1. Then with the text box selected, click in the formula bar, type "="
(w/out quotes), click on B1, press Enter.

HTH,
Andy
 
Back
Top