VBA code to Search and Replace all Data Validation Input Messages

Hi, I've just joined the forum and am a novice in VBA. I have an excel doc with multiple worksheets. I want to search and replace all data validation input messages in the workbook. Specifically, search for the following in input messages:

"RAG rating based on:
i) severity of risk to org
ii) extent to which these risks will impact org's ability to meet milestones, and looking ofrward, re-invesmtent criteria
R = significant risk; A = risks but sufficiently managed, G = no significant concerns"

And change it to:

"Consider risks to the org, specifically in relation to i) investment milestones and ii) entry criteria for the charity's next investment phase. Based on risks identified in this pillar, RAG rate ?net? of mitigation:
R = expect charity to miss milestones and/or fall short of reinvestment criteria;
A = charity is likely to miss milestones and/or fall short of reinvestment criteria;
G = on track.?

All solutions very gratefully received!
Thanks so much,
James

Unfortunately, you have to shorten your "story" to a maximum of 254 characters, including the characters of moving to a new line. After that, it will go easy.

Please Login or Register  to view this content.

Artik