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.

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.