How to display Excel 2002+ "Find & Replace" dialog via VBA

[Majorstratdude]

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

 

[Kassie]

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

works for me.