| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros using find/replace
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macros using find/replace
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? TB wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| Using Find and Replace to replace " in a macro | Excel Programming | |||
| Replace method - cannot find any data to replace | Excel Programming | |||
| Macros for find and replace and then joining columns | Excel Discussion (Misc queries) | |||
Linear Mode
