Testing and making announcments
Thread copied from this un
https://www.excelfox.com/forum/showthread.php/2417-Test-BB-Code-Highlighting-and-Colors
, on 19 July 2023
This is post #post21925
https://www.excelfox.com/forum/showthread.php/2910-Testing-and-making-announcments?p=21925&viewfull=1#post21925
, in Thread number 2910
Testing and making announcments
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 |
Worksheet: BluePrint
| 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
testing PowerShell Pretty colours
testing PowerShell Pretty colours
testing PowerShell Pretty colours
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
Get rid of redundant BB Code tag pairs in MS Word text
Get rid of redundant BB Code tag pairs in MS Word text
Get rid of redundant BB Code tag pairs in MS Word text