Using VBA, one can display most if not all of Excel's builtin
dialogs,
using code such as:

application,dialogs(xlDialogFormulaReplace).show


The object browser shows the enum for the constants (such as
xlDialogFormulaReplace in the example above). However, I cant find
such a constant for the new single box "Find & Replace" dialog
introduced in Excel 2002 and beyond and described in KB288291. Any
ideas on how to display this puppy?


Major

Cells.Replace What:="<your criteria>", Replacement:="<Your criteria>",
LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=False

works for me.

--
Hth

Kassie Kasselman
Change xxx to hotmail


"(E-Mail Removed)" wrote:

> Using VBA, one can display most if not all of Excel's builtin
> dialogs,
> using code such as:
>
> application,dialogs(xlDialogFormulaReplace).show
>
>
> The object browser shows the enum for the constants (such as
> xlDialogFormulaReplace in the example above). However, I cant find
> such a constant for the new single box "Find & Replace" dialog
> introduced in Excel 2002 and beyond and described in KB288291. Any
> ideas on how to display this puppy?
>
>
> Major
>
>