#1   Report Post  
Raymond Mitchell Raymond Mitchell is offline
Junior Member
 
Posts: 1
Cool Howdy Folks

Hoping you clever lot can help, I have a word doc with formfeilds - how do I make any newly entered text the colour of red and leave the old text black? I saw a similar VBA code for excel and wondered if it could be transferred to word.

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("A1:A100")) Is Nothing Then
If Target.Font.ColorIndex = 3 Then
Target.Font.ColorIndex = 5
Else
Target.Font.ColorIndex = 3
End If
End If

End Sub

Thank you in advance if you can help.

Cheers
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Here's a FUN challenge to Power Layout folks... Verticle LetterHea Rocky Page Layout 3 December 31st 09 07:51 AM
Question to Smarter Folks than I 1SgtMajor Microsoft Word Help 4 November 5th 09 01:06 PM
How do I keep a template attached when sending to folks off-site? CherylV Microsoft Word Help 3 October 18th 06 07:15 PM


All times are GMT +1. The time now is 11:53 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"