Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-09-2022, 12:33 AM
Jimmy Jimmy is offline A VBA macro can't get the correct color of a hyperlink in MS Word Windows 10 A VBA macro can't get the correct color of a hyperlink in MS Word Office 2019
Novice
A VBA macro can't get the correct color of a hyperlink in MS Word
 
Join Date: Jun 2022
Posts: 2
Jimmy is on a distinguished road
Default A VBA macro can't get the correct color of a hyperlink in MS Word

I'm writing a VBA macro that find any font color used except from black (RGB: 0,0,0) and blue.


If this macro finds a character that isn't black and blue in a paragraph, it shows the text of the paragraph with a message box.

Code:
Option Explicit

Sub test()

    Dim oParagraph As Paragraph, oLink As Hyperlink
    Dim char As Range
    Dim bFound As Boolean, i As Integer
    Dim strHex As String, strHex1 As String, strHex2 As String, strHex3 As String
    Dim strHex4 As String, strHex5 As String
    
    bFound = False
    
    For Each oParagraph In ActiveDocument.Paragraphs
    
        For Each char In oParagraph.Range.Characters
            strHex = Hex(char.Font.TextColor.RGB)
            strHex1 = Hex(char.Font.ColorIndex)
            strHex2 = Hex(char.Font.Color)
            strHex3 = Hex(char.Style.Font.Color)
            strHex4 = Hex(char.Style.Font.ColorIndex)
            strHex5 = Hex(char.Style.Font.TextColor.RGB)

            If char.Font.Color <> wdColorAutomatic And char.Font.Color <> wdColorBlack _
               And char.Font.Color <> wdColorBlue Then

                bFound = True
                GoTo nt_lb

            End If
        Next char

    Next oParagraph

nt_lb:
    If bFound = True Then
        MsgBox oParagraph.Range.Text
    End If

End Sub
But, this macro doesn't work for a hyperlink.
When you execute this macro, this macro shows the pragraph including the hyperlink although the hyperlnk is blue and the remaining text is black in the paragraph.

My macro checks the following properties for getting the correct font color:
  • Range.Font.Color
  • Range.Font.TextColor
  • Range.Style.Font.Color
  • Range.Style.Font.TextColor

But, any of the above properties don't return the correct color (blue).
In the hyperlink text "This is a test link.", this macro finds that the first "T" character isn't black and blue.

Also, I've attached a sample document.

Please help me.
Attached Files
File Type: docm sample.docm (18.2 KB, 7 views)
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to change an RGB table cell shading color to another RGB color David Matthews Word VBA 4 05-29-2018 02:45 PM
Correct Bookmark Hyperlink Phil H Word 2 02-10-2016 12:55 PM
A VBA macro can't get the correct color of a hyperlink in MS Word Word 2003 - Macro to color a row in table? cyberpaper Word 2 01-03-2013 02:07 PM
Word macro to email hyperlink pooley343 Word VBA 0 07-20-2011 01:48 AM
A VBA macro can't get the correct color of a hyperlink in MS Word Change Follwed Hyperlink color in Word 2010 Henry Word 1 07-05-2011 04:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:05 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