![]() |
#4
|
||||
|
||||
![]()
Try:
Code:
Sub GenderHilite() Dim Rslt Rslt = InputBox("Choose an option:" & vbCr & "1. Hilight Male" & vbCr & "2. Hilight Female" _ & vbCr & "3. Un-Hilight Male" & vbCr & "4. Un-Hilight Female") Select Case Trim(Rslt) Case "": Exit Sub Case 1: Call HighlightToggle(0, wdTurquoise) Case 2: Call HighlightToggle(1, wdPink) Case 3: Call HighlightToggle(0, wdNoHighlight) Case 4: Call HighlightToggle(1, wdNoHighlight) End Select End Sub Sub HighlightToggle(Gender As Long, Hilite As Long) Dim i As Long, StrGen As String StrGen = "<[Hh][Ee]> <[Hh][Ii][MmSs]> <[Hh][Ii][Mm][Ss][Ee][Ll][Ff]>|" & _ "<[Ss][Hh][Ee]> <[Hh][Ee][Rr]> <[Hh][Ee][Rr][Ss]> <[Hh][Ee][Rr][Ss][Ee][Ll][Ff]>" StrGen = Split(StrGen, "|")(Gender) Options.DefaultHighlightColorIndex = Hilite With ActiveDocument.Range.Find .ClearFormatting .Replacement.ClearFormatting .Format = True .Forward = True .Wrap = wdFindContinue .MatchWildcards = True .Replacement.Highlight = True For i = 0 To UBound(Split(StrGen, " ")) .Text = Split(StrGen, " ")(i) .Execute Replace:=wdReplaceAll Next End With End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
gender check |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Turning On Spell Checking Again | SQLUSA | Word | 9 | 08-01-2012 05:41 PM |
Checking n cells above's content | hanvyj | Excel | 4 | 03-22-2012 03:58 AM |
![]() |
mahenn45 | Word | 1 | 03-01-2012 01:05 AM |
![]() |
Deepy | Excel | 1 | 02-14-2011 05:06 PM |
Checking for DOS executions | ajetrumpet | Excel | 0 | 12-06-2009 02:33 PM |