Search text in worksheet

[Corgenius]

Dear colleagues,

Recently I've been trying to adapt a search code that I've found to try to find a word in a worksheet.

The code is meant to find, and select all cells that contains the text from an inputbox.
Code :

Please Login or Register  to view this content.

The only problem that I have is that I want to add a condition in it, and I don't know how.... I want the code to skip selecting valid cells (cells that have the inputbox word in them), that have the text size <10 . Recapping, now the code selects and displays all cells that have the inputbox word in them, but I want it to select just the ones that have the text size > 10. Any ideas would be appreciated.


Warm regards,


Eugeniu

[JOHN H. DAVIS]

What do you want too do once the cell has been selected? Create a list? Highlight?

[Corgenius]

Dear John,

The Workbook in which I will use this code is protected, so my options aren't that many:P. I just want to select the specific cell.

Warm regards,

Eugeniu

[Corgenius]

Any new idea will be appreciated .

[Corgenius]

Also, I've tried changing up the

Please Login or Register  to view this content.

in order to make it search just the cells that have text.size > 10. No luck.


Regards,

Eugeniu