Search form

  • Thread starter Thread starter Bernd
  • Start date Start date
B

Bernd

Hi!

I have this problem: when I call the normal search form to find a cell in
the active sheet (with STR+F), it works without problems. But when I call
the search form by the VBA command:
"application.Dialogs(xlDialogFormulaFind).Show"
I get the message that there is no such content. What could be wrong?

Thanks to all
Bernd
 
IIRC, for some reason the VBA statement does not work exactly like the menu
command when only a single cell is selected.
 
Hi Bernd
try the following:

activesheet.usedrange.select
application.Dialogs(xlDialogFormulaFind).Show
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using results from XLDIALOG commands 1
How to get Find dialogbox through VBA macro in Excel2007 11
Reset the macro assigned to Ctrl+F on workbook deactivate 11
Progmatically set "Application.Dialogs(xlDialogFormulaFind)" optio 3
Find and display 4
Find macro 2
Re : Making use of the Built-in Dialog Boxes 3
Insert "Find dialog box" edits into macro 3

Back
Top