View Single Post
 
Old 03-16-2013, 02:03 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,387
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Redbarn,

Try something along the lines of:
Code:
Sub ChangeColor()
Dim StrColor
StrColor = InputBox("Please choose a colour (by number):" & vbCr & _
  vbTab & "Auto" & vbTab & vbTab & "0" & vbCr & _
  vbTab & "Black" & vbTab & vbTab & "1" & vbCr & _
  vbTab & "Blue" & vbTab & vbTab & "2" & vbCr & _
  vbTab & "BrightGreen" & vbTab & "4" & vbCr & _
  vbTab & "DarkBlue" & vbTab & vbTab & "9" & vbCr & _
  vbTab & "DarkRed" & vbTab & vbTab & "13" & vbCr & _
  vbTab & "DarkYellow" & vbTab & "14" & vbCr & _
  vbTab & "Gray25" & vbTab & vbTab & "16" & vbCr & _
  vbTab & "Gray50" & vbTab & vbTab & "15" & vbCr & _
  vbTab & "Green" & vbTab & vbTab & "11" & vbCr & _
  vbTab & "Pink" & vbTab & vbTab & "5" & vbCr & _
  vbTab & "Red" & vbTab & vbTab & "6" & vbCr & _
  vbTab & "Teal" & vbTab & vbTab & "10" & vbCr & _
  vbTab & "Turquoise" & vbTab & "3" & vbCr & _
  vbTab & "Violet" & vbTab & vbTab & "12" & vbCr & _
  vbTab & "White" & vbTab & vbTab & "8" & vbCr & _
  vbTab & "Yellow" & vbTab & vbTab & "7", "Colour Picker", 0)
With Selection.Find
  .ClearFormatting
  .Text = ""
  .Highlight = True
  .Replacement.Text = ""
  .Replacement.Font.ColorIndex = StrColor
  .Replacement.Highlight = False
  .Forward = True
  .Wrap = wdFindContinue
  .Execute Replace:=wdReplaceOne
End With
End Sub
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote