VBA: "Replace" dialog box filled with values but not run

C

Cosimo

Hello,
I know how to use replace function in VBA to have some text replaced by some
other text;
but I can't find a way in VBA to show the Find&Replace dialog box with
"replace text" and "with text" boxed filled in by my macro

For example I want a user to clic on a button in a bar (and, of course, I
know how to create it) and to see the dialogue box with replace "Milan" with
"Rome" (these values must be writte in by the macro) but having the
opportunity to clic on "Replace" or "Replace all" or "Find next"

Thanks
Cosimo - Milan, Italy
 

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

Top