macros using find/replace

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I record a macro to bring up the dialog box for find/replace and leave
open. Each time I record and stop the macro after the box is open, it does
not stay open. The replaced data will be different each week and requires
the user to update.
 
Why do you want the dialog box to be open at all - why not just prompt
for the details (with a custom userform I would suggest) and then get
the macro to do the find and replacing using these parameters?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel wait for Find Replace dialog box in Word 4
Code to do a simple clean of one column by copying and pasting(finding and replacing) phrases in adj 4
Find/Find ALL 2
Macro to generate powerpoint slides 43
Macro to update other local macros 5
Client Access File Transfer from Excel 2010 4
Bring up the "find and replace" window 3
Open the Find & Replace Window Using a Macro 6

Back
Top