Search form
 

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

Search form
 

IIRC, for some reason the VBA statement does not work exactly like the menu
command when only a single cell is selected.

--

Vasant



"Bernd" wrote in message
y.telekom.at...
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

Search form
 

Hi Bernd
try the following:

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


-----Original Message-----
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


.

Search form
 

application.Dialogs(xlDialogFormulaFind).Show

works ok for me (Win 2000 & Excel 2000)