View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick S. Rick S. is offline
external usenet poster
 
Posts: 213
Default Progmatically set "Application.Dialogs(xlDialogFormulaFind)" optio

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?