Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pulling up the Find and Replace Dialog via Code
I have a macro that currently uses the Ctrl-F function, however when the Macro is unuseable (or going to error out) I would prefer to have the macro call the Find and Replace Dialog Box. The only hitch is that I cannot seem to find that dialog box in the list of presets. Thanks in advance for your help, John -- kraljb ------------------------------------------------------------------------ kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955 View this thread: http://www.excelforum.com/showthread...hreadid=500379 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pulling up the Find and Replace Dialog via Code
For the Find Dialog:
Dim WhatToFind As String WhatToFind = "asdf" Application.Dialogs(xlDialogFormulaFind).Show arg1:=WhatToFind For the Replace dialog Dim WhatToFind As String Dim ChangeToWhat As String WhatToFind = "asdf" ChangeToWhat = "qwer" Application.Dialogs(xlDialogFormulaReplace).Show _ arg1:=WhatToFind, arg2:=ChangeToWhat kraljb wrote: I have a macro that currently uses the Ctrl-F function, however when the Macro is unuseable (or going to error out) I would prefer to have the macro call the Find and Replace Dialog Box. The only hitch is that I cannot seem to find that dialog box in the list of presets. Thanks in advance for your help, John -- kraljb ------------------------------------------------------------------------ kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955 View this thread: http://www.excelforum.com/showthread...hreadid=500379 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FIND AND REPLACE DIALOG BOX | Excel Discussion (Misc queries) | |||
Excel Find/Replace Dialog Box | Excel Discussion (Misc queries) | |||
how to lock the find and replace dialog box in a corner | Excel Discussion (Misc queries) | |||
Find/Replace built-in dialog in XP | Excel Programming | |||
Find and Replace dialog box in VBA doesn't work suddenly | Excel Programming |