View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Majorstratdude@gmail.com is offline
external usenet poster
 
Posts: 4
Default How to display Excel 2002+ "Find & Replace" dialog via VBA

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