Search Multiple Text Boxes For A String

Hi all,

Have noticed in Excel (97) that CTRL-F (i.e find) will search the values of cells on the sheet, but does not search any text boxes on the page. I've been asked to write some code that trawls through a large report set up in Excel (that uses large text boxes for the text of the report) for a series of words and phrases.

However CTRL-F is disabled for looking in text boxes.

So any ideas how I might achieve this?

And as an addition (though less important) how to search graphs for the text as well.

Cheers,

Re: Search Multiple Text Boxes For A String

StefanG,

That's exactly what I was looking for.

Many thanks