Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to display Excel 2002+ "Find & Replace" dialog via VBA
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 " 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Find" a wildcard as a place marker and "replace" with original va | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
how to get vba to display excel 2002+ "Find & Replace" dialog | Excel Programming | |||
Replace dialog should put focus on "Find What" not "Replace With" | Excel Discussion (Misc queries) | |||
VBA code to display the "Find" (Ctrl+F) dialog box | Excel Programming |