Look at Find/FindNext in VBA help.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Austy" wrote in message
...
Hi,
I have made a userform to deal with data from 13 sheets in a work book.

I just don't want to use usual search and find from EDIT Menu

Can any one help me by giving a vba code to find a text which meets the
search criteria like between two dates and highlight it

Thanks
Austy