Format text in Word to look like code in VBA editor

mdbguy · #1 10-12-2018, 11:17 AM

I have miles of Excel VB code written by a long-gone predecessor. It's bad. Needs to be refactored.

I like to copy code into Word so it's easier to manipulate. But I'd like to colorize it like VB code, comments green, keywords blue, that sort of thing. Being unfamiliar with the Word object model, I thought I'd ask for a boost.

I need basic syntax to find all occurrences of a given string and change the color. I think I can handle the rest. Thanks so much!

mdbguy · #2 10-12-2018, 11:39 AM

Thanks anyway...I got it.

slaycock · #3 10-13-2018, 03:02 AM

If you are trying to refactor VBA code then RubberDuck is a strong ally.

http://rubberduckvba.com/

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word MergeField Code Text issue	stevenel	Mail Merge	17	09-27-2018 09:12 PM
creating a code to create dynamic text in word	ah8471	Word VBA	1	12-29-2015 10:52 PM
Macro to select an { includepicture } field code and format the picture behind text and 100% scale	sanpedro	Word VBA	3	03-30-2015 10:50 PM
VBA code for Microsoft Word macro — select text and insert footnote	ndnd	Word VBA	10	01-06-2015 01:47 PM
VBA code to format a document containing tables	rasika99	Word VBA	3	12-12-2014 04:16 AM