Text Boxes

  • Thread starter Graham Parkinson
  • Start date
G

Graham Parkinson

I have a number of text boxes within charts that
highlight some of the information. I change the data that
produces the charts and would like to automatically
change the text in the text box by linking the text box
to cells within a worksheet. Is this possible to do?

Thanks

Graham
 
J

JulieD

Hi Graham

you can link a text box to a cell,
1) click on the text box
2) click in the formula bar
3) type
=A1
(or whatever cell)
4) press enter

Cheers
JulieD
 
A

Andy Brown

1) click on the text box

Unless you click exactly on the border, this'll put you in the box. If you
have a crappy mouse (or DTs? <g>), hover anywhere over the box, then hold
down CTRL & click.

Rgds,
Andy
 
Top