Hello,
I'm new to the forums and very new to VBA. I feel like I've been able to accomplish quite a bit through internet searches, but I've come across something that I just can't find an answer to. I have an excel sheet that gathers data and formats it into charts using several macros controlled by buttons. I then have a SendtoWord macro that opens a specific Word template, copies each of the 20 charts, finds the appropriate bookmark in the Word document, and pastes each chart into the correct location (all one chart at a time). The charts are 2 in. x 3.5 in. in Excel so that I can see several at a time on the screen, but they are larger in Word because they're meant to be printed for posting around the office. As each chart is pasted into Word, the macro selects it and changes the size of the chart itself as well as the data label, legend, and title font sizes. Then it moves onto the next chart.

Here comes the problem... I've added a text box to each of the charts in Excel. The text within the boxes updates every time the charts update. If I run my SendtoWord macro, it still works great as far as what I described above. The new text boxes do copy over with the charts, but I can't figure out how to then grab the text box to change the font size like I have with the other items.

Here's the code that I currently have for one chart for the above process:
ActiveSheet.ChartObjects("FRP_Month").Copy
    Set wdRng = wdDoc.Bookmarks("FRP_Month").Range
    wdRng.Paste
    wdRng.Select
    With wdApp.Selection.InlineShapes(1)
        .Height = InchesToPoints(LineChartHeight)
        .Width = InchesToPoints(LineChartWidth)
        .Line.Visible = msoFalse
        .Chart.SeriesCollection(1).DataLabels(1).Font.Size = ChartDataFont
        .Chart.SeriesCollection(1).DataLabels(2).Font.Size = ChartDataFont
        .Chart.SeriesCollection(1).DataLabels(3).Font.Size = ChartDataFont
        .Chart.Legend.Font.Size = ChartDataFont
        .Chart.ChartTitle.Font.Size = ChartTitleFont
    End With
Note: LineChartHeight, LineChartWidth, ChartDataFont, and ChartTitleFont are predefined integers that I've set with the sizes that I want for each item.

I understand (or at least I guess) that it will be handled differently because the textbox isn't a native object of the chart. Somehow I need to select the textbox within the selected chart. I've tried using the ShapeRange, TextFrame, and TextRange objects in different combinations. I even tried using InlineShapes(2) thinking that it might be seen as a different shape within the selected range. Also, there are other text boxes in the Word template that I don't want to change, so I can't just do a blanket change to all text boxes in the document.

Is anyone able to help me figure out how to edit a textbox within a chart in Word from Excel VBA?

Thank you very much ahead of time.