Page 4 of 4 FirstFirst ... 234
Results 31 to 38 of 38

Thread: Testing and making announcments

  1. #31
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10
    Test Burgandy

    Generic color name: Burgundy
    Colors that make up #8C001A
    RGB: 140, 0, 26 - HSL: 0.97, 1.00, 0.27

    Purple[COLOR="#800080"]Purple[/COLOR]
    Purple[COLOR=Purple]Purple[/COLOR]
    Maroon[COLOR="#800000"]Maroon[/COLOR]
    Maroon[COLOR=Maroon]Maroon[/COLOR]
    Burgundy[COLOR="#8C001A"]Burgundy[/COLOR]
    Windows10[color="#3E0000"]Windows10[/COLOR]
    color:#A82D00 $NFS




    HTML Code:
    <div class=WordSection1>
    
    <p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;line-height:115%;
    font-family:"Lucida Console";mso-bidi-font-family:"Lucida Console";color:#A82D00;
    mso-ansi-language:EN-GB;mso-fareast-language:DE'>$NFS</span><span lang=EN-GB
    style='font-size:9.0pt;line-height:115%;font-family:"Lucida Console";
    mso-bidi-font-family:"Lucida Console";mso-ansi-language:EN-GB;mso-fareast-language:
    DE'><span style='mso-spacerun:yes'>                             </span><span
    style='color:dimgray'>=</span> <span style='color:blue'>New-Object</span> <span
    class=SpellE><span style='color:blueviolet'>system.Windows.Forms.Button</span></span></span><span
    lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
    
    </div>
    Code:
    'Sub Makro9BBBurgundy()   '   '     https://excelfox.com/forum/showthread.php/2417-Test-BB-Code-Highlighting-and-Colors?p=16370#post16370
    '    With Selection
    '     .Font.Color = 1704076
    '     .Text = "[color=""#8C001A""] " & .Text & " [/color]"
    '     .Collapse Direction:=wdCollapseEnd
    '    End With
    'End Sub
    Sub Makro9BBBurgundy() '    Ctrl+Shift+B,G   '  https://eileenslounge.com/viewtopic.php?f=26&t=37808&p=292620#p292620
        Dim Text1 As String
        Dim Text2 As String
        Text1 = "[color=""#8C001A""] "
        Text2 = " [/color]"
        With Selection
            .InsertBefore Text:=Text1
            .InsertAfter Text:=Text2
            ActiveDocument.Range(Selection.Start, Selection.Start + Len(Text1)).Font.Size = 8
            ActiveDocument.Range(Selection.End - Len(Text2), Selection.End).Font.Size = 8
            .Font.Color = 1704076
            .Collapse Direction:=wdCollapseEnd
        End With
    End Sub
    A Folk, A Forum, A Fuhrer ….

  2. #32
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10
    Spare Post

    Last edited by DocAElstein; 07-19-2023 at 02:07 PM.
    A Folk, A Forum, A Fuhrer ….

  3. #33
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10
    Spare Post

    Last edited by DocAElstein; 07-19-2023 at 02:07 PM.
    A Folk, A Forum, A Fuhrer ….

  4. #34
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10
    Spare Post

    Last edited by DocAElstein; 07-19-2023 at 02:07 PM.
    A Folk, A Forum, A Fuhrer ….

  5. #35
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10

    Get rid of redundant BB Code tag pairs in MS Word text

    Test

    [COLOR=black][b]This will usually be black anyway[/b], not [color=orange]orange[/color], ([/COLOR] [color=purple]Purple[/color] [COLOR=black] is my favourite ) so I really don’t need the black color BB Code tag pairs [/COLOR]
    This will usually be black anyway, not orange, ( Purple is my favourite ) so I really don’t need the black color BB Code tag pairs


    [b]This will usually be black anyway[/b], not [color=orange]orange[/color], ( [color=purple]Purple[/color] is my favourite ) so I really don’t need the black color BB Code tag pairs
    This will usually be black anyway, not orange, ( Purple is my favourite ) so I really don’t need the black color BB Code tag pairs




    Trying to do that with wild stuff, makes my brain hurt a lot......
    Answer from Stuart at Eileen'sLounge: https://eileenslounge.com/viewtopic....299529#p299529
    https://i.postimg.cc/mDvfF9HP/Stuarts-In-German.jpg


    Code:
    Sub RemoveBlackBBCodeTagPairs() ' https://eileenslounge.com/viewtopic.php?p=299529#p299529
    Selection.Find.ClearFormatting
    Selection.Find.Replacement.ClearFormatting
        With Selection.Find
         .Text = "\[COLOR=black\](*)\[/COLOR\]"
         .Replacement.Text = "\1"
         .Forward = True
         .Wrap = wdFindAsk
         .Format = False
         .MatchCase = False
         .MatchWholeWord = False
         .MatchKashida = False
         .MatchDiacritics = False
         .MatchAlefHamza = False
         .MatchControl = False
         .MatchAllWordForms = False
         .MatchSoundsLike = False
         .MatchWildcards = True
        End With
    Selection.Find.Execute Replace:=wdReplaceAll
    End Sub
    Hans simplified

    Code:
    ' https://eileenslounge.com/viewtopic....299537#p299537
    Sub RemoveBlackBBCodeTagPairs() '
        With Selection.Find
            .ClearFormatting
            .Replacement.ClearFormatting
            .Text = "\[COLOR=black\](*)\[/COLOR\]"
            .Replacement.Text = "\1"
            .MatchWildcards = True
            .Execute Replace:=wdReplaceAll
        End With
    End Sub
    A Folk, A Forum, A Fuhrer ….

  6. #36
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10

    Get rid of redundant BB Code tag pairs in MS Word text

    Spare Post

    Last edited by DocAElstein; 07-19-2023 at 02:07 PM.
    A Folk, A Forum, A Fuhrer ….

  7. #37
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10

    Get rid of redundant BB Code tag pairs in MS Word text

    Spare Post

    Last edited by DocAElstein; 07-19-2023 at 02:08 PM.
    A Folk, A Forum, A Fuhrer ….

  8. #38
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10

    Get rid of redundant BB Code tag pairs in MS Word text

    Spare Post

    Last edited by DocAElstein; 07-19-2023 at 02:08 PM.
    A Folk, A Forum, A Fuhrer ….

Similar Threads

  1. testing
    By Jewano in forum Test Area
    Replies: 7
    Last Post: 12-05-2020, 03:31 AM
  2. Replies: 18
    Last Post: 03-17-2019, 06:10 PM
  3. VBA Trick of the Week: Range to Recordset Without Making Connection
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 07-11-2013, 06:21 PM
  4. Data sorting & Graph making according filters
    By leopaulc in forum Excel Help
    Replies: 2
    Last Post: 04-05-2012, 08:56 AM
  5. Making a Histogram Chart Using Arrays
    By Rasm in forum Download Center
    Replies: 2
    Last Post: 04-05-2011, 07:22 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •