Why not use the VBA find, check it out in Help.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Rick S." wrote in message
...
The bit of code below opens the "find" dialog box with the text supplied
by a
textbox on a userform.
sFindMe = TextBox1.Value
Application.Dialogs(xlDialogFormulaFind).Show sFindMe

What I would like to do is set the search arguments and pass an "Enter"
key
response with out user interaction to the "find" dialog box.
Basically the user would never see the dialog box at all. Trust me, its
necessary. ;)

Is this possible?