Use a textbox to display a cell value 1

[Jamie2002]

I'm looking at putting boxes over a graph with further information about the graph. I have created a textbox off the Control Toolbox and thought the easiest way would be to use the linkedcell option.

If for instance I want to link to a cell in a sheet called "Graph Data" and it's Cell A5 what do I need to type into this LinkedCell property box ?

Thank you. Thanks

Jamie

 

[Loomah]

Hi Jamie
try "Graph Data!A5"
The quotes are needed as you have spaces in your sheet name.

;-) If a man says something and there are no women there to hear him, is he still wrong?
"...Three Lions On A Shirt..."