brothertruffle880
asked on
word 2013 VBA - Search for a character string. Stop and display that character string
I'd like to have a macro where I
1. Search for the word "cat" or "CAT" or "cAt" or any combination of upper/lower case.
2. I want the macro to stop when it finds that character string and allow me to see what it found.
3. I want the macro to generate a YES NO CANCEL message box
3a. YES will
i. extend the selection to the next hard return (enter key) symbol
ii. backspace one character from the hard return character, and
iii. exit the macro.
3b NO will deselect what it found, move forward one character and go to step 1 above.
3c CANCEL will exit the macro.
1. Search for the word "cat" or "CAT" or "cAt" or any combination of upper/lower case.
2. I want the macro to stop when it finds that character string and allow me to see what it found.
3. I want the macro to generate a YES NO CANCEL message box
3a. YES will
i. extend the selection to the next hard return (enter key) symbol
ii. backspace one character from the hard return character, and
iii. exit the macro.
3b NO will deselect what it found, move forward one character and go to step 1 above.
3c CANCEL will exit the macro.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Have a great weekend.