Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-05-2022, 05:38 AM
Harvi007 Harvi007 is offline VBA Marco to change font colour of every other word Windows 11 VBA Marco to change font colour of every other word Office 2019
Novice
VBA Marco to change font colour of every other word
 
Join Date: Aug 2022
Posts: 11
Harvi007 is on a distinguished road
Question VBA Marco to change font colour of every other word

Hi Everyone,



I wonder if anyone can help me out with a VBA macro.

I have a word document and I'd like to change the font colour of every other word, so either all the odd words are say Red or all the even words are Red, the remaining words stay the default colour.

So I initially started with a word count in the hope of changing this to only count odd or even words, but this didn't work out for me.

I then went on to loading all the words into an array with the hope of picking out the odd or even indexed words and the somehow change the colour, but again I'm stuck and can't work out how to do it.

I'm not an expert but can do the basics, I've looked around on the web and found something that came close, it changed the colour of every letter but even then it was based on case, so if it was A it would be Red and B would be Blue. It worked, but this didn't help me as I couldn't work out how to get it to look at the words.

For the record, a word I'm referring to as text in-between 2 spaces. As I'm working with a different language, sometimes you with get numbers which are not words but are in-between spaces and thus would be treated as a 'word'.

Is there anyone that could help and guide me on how I can attain my goal?

Any help would be much appreciated.

Thank you
Reply With Quote
 

Tags
macro font colour, vba change colour



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word Macro Recorder does not record font colour selection Ramkay Word 1 12-02-2020 07:48 AM
VBA Marco to change font colour of every other word VBA - Word how to globally change the font and font size in footnotes thomasoj Word VBA 3 01-15-2020 06:26 AM
VBA Marco to change font colour of every other word VBA to change font colour in email body on send RealmOfCOnfusion Outlook 1 06-30-2016 09:55 PM
VBA Marco to change font colour of every other word Change font colour when tasks are completed meileetan Project 3 09-12-2012 07:09 AM
VBA Marco to change font colour of every other word Change Colour Theme in Word with VBA Davidoff78 Word VBA 1 06-28-2012 05:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft