Hi! I don't know if anyone can help me with this. I would like to find a text (which may vary for example: rev1 or rev 1) in an excel file provided the worksheet is specified using VB6 and show only the 1 (instead of rev1) in a textbox.

Example:

excel file = helpme.xls (with 3 worksheets available is help1, help2, help3)
specified worksheet = help1
text to find = rev1 (or rev 1 --> there may be times where there is a space between rev and 1.)
text to show in textbox = 1

Please help.