Link to home
Start Free TrialLog in
Avatar of Luis Diaz
Luis DiazFlag for Colombia

asked on

Excel VBA: replace strings based on selection

Hello experts,

I am looking for a procedure to add to my personal.xlsb that cover the following requirement:

1-Inputbox: Please select the range which contains the string to replace
2-Inputbox: Please select the range which contains the string which will replace the previous selected string
3-Inputbox: Please select the sheet in which you want to apply the replacement

Replace reported in inputbox 1 by the one report'ed in inputbox 2

If you have questions, please contact me.
ASKER CERTIFIED SOLUTION
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bill Prew
Bill Prew

I tend to agree with Rob on this one, it feels like the built in Replace is so close to this I couldn't even bring myself to trying to wrap it in a VBA procedure.  Bigger fish to fry as they say...


»bp
Avatar of Luis Diaz

ASKER

You are right.
Thank you very much for your advice.