Why don't use use the FIND in the edit menu on the worksheet? Remember to
open up the options window and change Sheet to Workbook.

"aftamath77" wrote:

I have a workbook that has nearly a hundred different sheets. I would like
to create a userform and module that will search each cell in each worksheet
for specific text.