title: Iterate through all text (in cells, charts, textboxes) in Excel using vba
body: <p>I built a function to search for and replace specific text throughout an entire excel document. I can go through the entire document and all its cells just fine using </p>
  
  <pre><code>For Each WS In Worksheets
      For Each ActiveCell In WS.UsedRange
          If ActiveCell &lt;&gt; "" Then
              ActiveCell.Value = ReplaceWord(ActiveCell.Value, Search, Replacement)
          End If
       next
  next
  </code></pre>
  
  <p>This works, but a lot of the documents have charts with titles in textboxes and other places and I am not sure how to access those without knowing their exact names etc.
  Basically I would like to do a search for every single string in the excel document and use my ReplaceWord function to replace the words. But I am lost on how :)</p>
  
  <p>Any help would be much appreciated. Thanks!</p>