Search form

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
 
V

Vasant Nanavati

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

Frank Kabel

Hi Bernd
try the following:

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

AA2e72E

application.Dialogs(xlDialogFormulaFind).Show

works ok for me (Win 2000 & Excel 2000)
 
Top