find and point to a string within a cell's comment

[bromberg]

I was wondering if it is possible to write an Excel macro that would not just point to a string that I am searching for within a comment, but also open that comment
and leave the cursor blinking on the line where the match was found.

My problem is that I have a spreadsheet with many sheets and many comments within many cells, and the default action that Excel takes by just pointing to the comment that contains the match is not good enough. I then have to open the comment and cut & paste its contents into NOTEPAD and then perform another search on the string I am after!
Since I do this a lot it turns out to be a huge consumption of my time and something a macro should be able to do, don't you think?

 

[Chihiro]

You'll want to go through the link. There's many code samples that you can adopt to your need.

http://www.contextures.com/xlcomments03.html
http://blog.contextures.com/archives/2010/08/27/print-a-customized-list-of-excel-comments/

 

[bromberg]

You'll want to go through the link. There's many code samples that you can adopt to your need.

http://www.contextures.com/xlcomments03.html
http://blog.contextures.com/archives/2010/08/27/print-a-customized-list-of-excel-comments/

Thanks for the links, but they don't really answer my immediate question. I don't presently have the time to learn to modify existing macros to solve my issue, but I appreciate your suggestion.
Dan