Search Excel Comments

[tedc]

Hi
I'm looking for a macro that I could attach to button that would give me search options for added comments in cells. The sheet contains a number of these comments all in the same column. It would entail searching for a word or words
Can anyone help please

Ted

 

[mikerickson]

The built in Find feature has a Look in Comments option.

 

[tedc]

Thank you mike

 

[tedc]

That works okay... but what I really would need is a macro that would open the comments, and bold text the search results. Is this possible. Some of the comments hold a far bit of information and the same search results could appear in multiple comments.
cheers
Ted