Test BB Code Highlighting and Colors
Ref:
https://www.excelforum.com/developme...ml#post4533692
Test test test test test
testing Highlighting with BB code code tags
Trying to get my Blue Testies
( aka Making Albert Einstein's Testies Blue http://www.excelforum.com/excel-prog...ml#post4533677 )
:rolleyes:
From here:
http://www.excelforum.com/the-water-...cel-forum.html
Looking at Rory’s ! ( by hitting Reply with quote and copying .. )
[size=2][Table]
[tr=bgcolor:red][td=bgcolor:#blue]Hi Excel Forum.[/td][/tr]
[/table][/size]
_.............................
[size=2][Table]
[tr=bgcolor:lightBlue][td=bgcolor:#black]Hi Excel Forum.[/td][/tr]
[/table][/size]
........................
[size=2][Table]
[tr=bgcolor:lightBlue][td=bgcolor:#white]Hi Excel Forum.[/td][/tr]
[/table][/size]
_...........................
[size=2][Table]
[tr=bgcolor:lightBlue][td=bgcolor:white]Hi Excel Forum.[/td][/tr]
[/table][/size]
_..........................
[size=2][Table]
[tr=bgcolor:lightBlue][td=bgcolor:lightblue]Hi Excel Forum.[/td][/tr]
[/table][/size]
_........................................
[size=2][Table]
[tr=bgcolor:white][td=bgcolor:lightblue]Hi Excel Forum.[/td][/tr]
[/table][/size]
_........................................
[size=2][Table]
[tr][td=bgcolor:lightblue]Hi Excel Forum.[/td][/tr]
[/table][/size]
_........................................
[size=2][Table]
[tr][td=bgcolor:lightblue][COLOR="#FFFFFF"]Hi Tony. How are you? This will do me to demo how some thing looks when Highlighted in the VB Editor Code Window :)[/COLOR] [/td][/tr]
[/table][/size]
| Hi Tony. How are you? This will do me to demo how some thing looks when Highlighted in the VB Editor Code Window :) |
_........
or http://www.excelforum.com/showthread...77#post4533677
[size=1][Table]
[tr][td=bgcolor:lightblue][COLOR="#FFFFFF"] [size=2]highlight any occurrence of that Workbook variable[/size]
[/COLOR][/td][/tr][/table][/size]
highlight any occurrence of that Workbook variable
|
_.........
Or Finally my favourate
_ Edit
ignor my testies !
Rory Tools, no Grid or Header
[size=2][Table]
[tr=bgcolor:#FFFFFF][td=bgcolor:#FFFFCC]This must be correct Time Format[/td][/tr]
[tr=bgcolor:#FFFFFF][td][/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#D99795]This must be Correct Date Format [/td][/tr]
[/table][/size][size=0][color=lightgrey]Worksheet: [/color][b][color=darkblue]BluePrint[/b][/color][/size]
| This must be correct Time Format |
|
| This must be Correct Date Format |
| Index( Arr() , Rws(), Clms() ) ) |
[size=1][Table]
[tr][td=bgcolor:lightgrey] [I][B][FONT=Courier New][size=3]Index( Arr() , Rws(), Clms() ) )[/size][/FONT] [/B][/I] [/td][/tr]
[/table][/size]
testing PowerShell Pretty colours
Get-Service|Select-Object name,displayname,starttype|Format-Table -AutoSize|Out-File -FilePath\ 'C:\Users\acer\Desktop\test.txt' -Width 1000
Get-Service|Select-Object name,displayname,starttype|Format-Table -AutoSize|Out-File -FilePath\ 'C:\Users\acer\Desktop\test.txt' -Width 1000
Get-Service|Select-Object name,displayname,starttype|Format-Table -AutoSize|Out-File -FilePath\ 'C:\Users\acer\Desktop\test.txt' -Width 1000
Get-Service|Select-Object name,displayname,starttype|Format-Table -AutoSize|Out-File -FilePath\ 'C:\Users\acer\Desktop\test.txt' -Width 1000
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
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
