View Single Post
Old 11-26-2014, 03:17 AM
tarktran tarktran is offline Windows 7 64bit Office 2010 64bit
Join Date: Nov 2014
Posts: 1
tarktran is on a distinguished road
Default Macro to find coloured text and replace with form-field/formtext containing that text

I am trying to do the following (whether it can be manually done OR done using VBA), please note I only have a real basic understanding of VBA.

What I am trying to achieve is:

1.) Search all text in the colour RED;
2.) Replace ALL text that appears in the colour RED and insert them in a {FORMTEXT} / textform while maintaining the text colour if possible.

Or alternatively if that is not possible:

1.) Search for the word "cash" and;
2.) Replace it with a FORMTEXT with the text inserted to them

If I can visibly see in the VBA code where the adjustments are required if I need to change the keyword to for example "month" then at least I can easily amend the code.

Much appreciation to whomever views this thread and can help me out with a solution.

Reply With Quote