+ Reply to Thread
Results 1 to 4 of 4

Confirmation in Search and replace VBA

  1. #1
    Forum Contributor
    Join Date
    01-18-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    202

    Confirmation in Search and replace VBA

    I have a routine which replaces everything between brackets in my document.

    It works fine and runs though the text from top to bottom without stopping.

    Please Login or Register  to view this content.

    However , I'd like now to modify it so it stops and asks whether to replace or not each time it finds the target. Perhaps it needs a different routine.

    Grateful for any advice.
    Last edited by CDandVinyl; 05-22-2020 at 01:38 AM.
    Using Excel , Word and Access 2003 - September 1st 2020

  2. #2
    Forum Contributor
    Join Date
    01-18-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    202

    Re: Confirmation Dialogs in Search and Replace VBA

    Ok I've managed to find a solution to this.

    These amendments brings up a dialog to confirm the Replace.


    Please Login or Register  to view this content.
    Last edited by CDandVinyl; 05-22-2020 at 12:24 PM.

  3. #3
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,441

    Re: Confirmation in Search and replace VBA

    Try:
    Please Login or Register  to view this content.
    The .Execute method takes you to the first found instance after the current selection.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  4. #4
    Forum Contributor
    Join Date
    01-18-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    202

    Re: Confirmation in Search and replace VBA

    Yes - very neat. Thank you.



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Search and replace Text Replace Formula
    By Vonblack in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-21-2019, 11:30 AM
  2. Macro: Search and replace: Replace using a cell reference
    By kalyan46 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2019, 07:11 PM
  3. [SOLVED] How to replace specific text search for any date search
    By katiedee1625 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2018, 11:22 AM
  4. Search and Replace
    By hsalazar in forum Excel General
    Replies: 2
    Last Post: 02-09-2012, 10:25 AM
  5. Search and replace VB with VB
    By Mayweed in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-14-2011, 08:02 AM
  6. Search and replace
    By soprano in forum Excel General
    Replies: 9
    Last Post: 05-16-2008, 07:58 AM
  7. Limit Search & Replace's Replace All?
    By Bob@1800-mail.com in forum Excel General
    Replies: 4
    Last Post: 08-03-2006, 02:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1