R
Rick S.
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?
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?