simone.water
New Member
- Joined
- Jun 14, 2010
- Messages
- 1
I'm using Excel 2007.
I have a large number of charts, and a text box within each chart that each reference the same cell. I now want to change which cell each text box references.
Is there an easy way to do this (with or without VBA)? It is tedious finding and selecting the text boxes, and manually changing the cell reference.
I have a large number of charts, and a text box within each chart that each reference the same cell. I now want to change which cell each text box references.
Is there an easy way to do this (with or without VBA)? It is tedious finding and selecting the text boxes, and manually changing the cell reference.
