![]() ![]() With the text boxes and chart labels tied to worksheet cells, you can easily use Find and Replace to search for and change information in the cells. ![]() You can use the same technique with custom chart labels-all you need to do is select the chart label and enter a cell reference in the Formula bar. Repeat steps 2 and 3 for each of your other text boxes, using the appropriate cell reference for each in step 3.When you press Enter, the text box should reflect whatever is in cell Z1. With the text box still selected, enter the following into the Formula bar: =Z1.Select the first text box (the one that corresponds to cell Z1) and get rid of the text box's contents.(For this example, assume that you copied the contents of ten text boxes to the range Z1:Z10.) Copy your text from each of text boxes to a range of cells on your worksheet.For instance, you could do the following for your text boxes: The short answer is that it is not possible, but there are several workarounds you can try.įirst, you could easily make the text in your text boxes or in your chart labels dynamic, so that it is tied to the contents of some worksheet cells. David wonders if it is possible to use Find and Replace to locate and modify text in text boxes or in labels in charts.
0 Comments
Leave a Reply. |