PDA

View Full Version : Testing and making announcments



DocAElstein
02-02-2020, 12:26 AM
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

DocAElstein
02-02-2020, 12:26 AM
Ref:
https://www.excelforum.com/development-testing-forum/1158640-test-highlighting-text.html#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-programming-vba-macros/1165091-copy-data-from-one-workbook-to-an-other.html#post4533677 )
:rolleyes:


From here:
http://www.excelforum.com/the-water-cooler/1144074-hi-excel-forum.html

Looking at Rory’s ! ( by hitting Reply with quote and copying .. )



Hi Excel Forum.




Hi Excel Forum.



_.............................


Hi Excel Forum.




Hi Excel Forum.


........................




Hi Excel Forum.




Hi Excel Forum.


_...........................



Hi Excel Forum.




Hi Excel Forum.



_..........................



Hi Excel Forum.




Hi Excel Forum.


_........................................



Hi Excel Forum.




Hi Excel Forum.



_........................................



Hi Excel Forum.




Hi Excel Forum.



_........................................



Hi Tony. How are you? This will do me to demo how some thing looks when Highlighted in the VB Editor Code Window :)




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.php?t=1165091&p=4533677#post4533677



highlight any occurrence of that Workbook variable





highlight any occurrence of that Workbook variable




_.........



Or Finally my favourate


Fuck Bollox Wank




_ Edit
ignor my testies !

Rory Tools, no Grid or Header


This must be correct Time Format



This must be Correct Date Format
Worksheet: BluePrint



This must be correct Time Format



This must be Correct Date Format
Worksheet: BluePrint



Index( Arr() , Rws(), Clms() ) )


Index( Arr() , Rws(), Clms() ) )

DocAElstein
11-15-2020, 04:25 PM
== A == == A ==



xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx



== B == == B ==



xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx





== C == == C ==



xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx



== D == == D ==



xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

== F == == F ==

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx



== G == == G ==



xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx





== H == == H ==





xxxxx xxxxx

xxxxx xxxxx



== I == == I ==



xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx



== K == == K ==



xxxxx xxxxx



== L == == L ==



xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx



== M == == M ==



xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx



== N == == N ==



xxxxx xxxxx

xxxxx xxxxx



== O == == O ==

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx



== P == == P ==

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx



== R == == R ==



xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx



== S == == S ==



xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx



== T == == T ==

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx



== V == == V ==



xxxxx xxxxx



== W == == W ==



xxxxx xxxxx

xxxxx xxxxx

xxxxx xxxxx



== Y == == Y ==



xxxxx xxxxx

xxxxx xxxxx

DocAElstein
11-15-2020, 04:25 PM
Spare Post

DocAElstein
11-15-2020, 05:53 PM
Beautiful


xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx


xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx

xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx

xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx

xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx"#9900ff""#0000CD""#cc00ff"blueviolet"#9900ff"
xxxxblueviolet"#9900ff"blueviolet"#9900ff"
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx

xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx


xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx


xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx

xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx

xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx
xxxxx xxxxx

DocAElstein
11-15-2020, 05:53 PM
Spare Post

DocAElstein
12-20-2020, 02:07 PM
Get the Color shade you want to come out in Final Post

I expect there is a better way to do this, but I just hit on a way that works quite well, so I will document and share that now , and edit and update later if I come up with a more scientific and/ or automated way.

As an example , say I have seen this: _ shade _ somewhere, as you see it here, ( there ) . Lets assume I want to post that word in a Forum editor which accepts BB Code tags, ( BB Code tags: http://www.excelfox.com/forum/misc.php?do=bbcode ) such that I get that _ shade _ in the final post just as you see it here ( there )

Here is a way to do it:
_1 ) Use Word to get the shade of shade that you want,
:rolleyes: :for example,
_ 1A) highlight any text and experiment with its color:
Word Text Color 0.JPG : https://imgur.com/xpCoo8B
Word Text Color 1 2.JPG : https://imgur.com/agdUo2f
Word Text Color 3.JPG : https://imgur.com/H5czlGV
Word Text Color 4.JPG : https://imgur.com/2ff71Xq
( Hit OK when finished to change selection color)
1981198219831984

_ 1B) As an alternative start point, you can find any text color anywhere, for example in the internet, paste into Word and adjust it in Word as per _ 1A)

_2 ) Copy the final Text to the clipboard.
Search the internet for any Word to HTML converter, there are many free ones available. Typically you can paste anything into a Visual Editor and then choose to obtain the HTML code
WordVisualToHTML.JPG : https://imgur.com/T19SMxG
1980

_3 ) In the given HTML code will typically be some part referring to the text shade,_..

<p><span style="font-size: 11pt; line-height: 115%; font-family: Verdana, sans-serif; color: #417394;">shade</span></p>
_.. here for example, the number of interest is _ color: #417394

_4 ) I assume the number used in the square bracket [ BB Code Color Tags ] pair is the same as in pointy bracket < HTML > code Tags color bit. It appears to be.
So for our example shade you would use this in a forum post_..
____ shade
_.. which would come out like this:
__________________ shade

( If you want to keep the indent, as I did here (there), and avoid the forum editor “eating” spaces of more than one, ( as most forum editors do this ) ) , then use the white character trick: Post something like this:
_ Any_White_Profanity Text shade




Alan

DocAElstein

DocAElstein
https://imgur.com/MKMjW0b



Ref
http://www.excelfox.com/forum/showthread.php/2057-Code-Mod-to-prevent-further-Replacement-Text-over-complete-Document
https://imgur.com/MKMjW0b
http://www.excelfox.com/forum/misc.php?do=bbcode
https://wordtohtml.net/
http://services.runescape.com/m=forum/forums.ws?278,279,877,64690220
http://www.excelfox.com/forum/showthread.php/2146-%E0%A4%AC%E0%A5%8D%E0%A4%B2%E0%A5%89%E0%A4%97-%E0%A4%95%E0%A5%8B%E0%A4%B6%E0%A4%BF%E0%A4%B6-%E0%A4%95%E0%A4%B0-%E0%A4%B0%E0%A4%B9%E0%A4%BE-%E0%A4%B9%E0%A5%88-%D8%A8%D9%84%D8%A7%DA%AF%D8%B2-%DA%A9%DB%8C-%DA%A9*Trying-Blogs/page2#post10131

DocAElstein
12-20-2020, 02:07 PM
Spare Post

DocAElstein
10-24-2021, 12:46 PM
Test

Direct link for forum form post immages org
https://i.postimg.cc/prQ07WPb/Here-Excel-forum-colors-ohne-rand-Eillen.jpg (https://postimages.org/)

https://i.postimg.cc/NGRPL4mJ/Here-Excel-fox-colors-ohne-rand-Eileen.jpg (https://postimages.org/)


now change link to post images to link you want to go to
https://i.postimg.cc/y6wgpmGH/here-Excel-forum-colors-ohne-rand-Eillen.jpg (https://www.excelforum.com/excel-programming-vba-macros/343845-docking-project-explorer-vertically.html#post4545938)

https://i.postimg.cc/GhGBWB0s/here-Excel-fox-colors-ohne-rand-Eileen.jpg (https://excelfox.com/forum/showthread.php/2345-Appendix-Thread-(-Codes-for-other-Threads-HTML-Tables-etc-)?p=15706&viewfull=1#post15706)


https://i.postimg.cc/tCYHrddF/blowup.gif (https://excelfox.com/forum/showthread.php/2417-Test-BB-Code-Highlighting-and-Colors?p=15707&viewfull=1#post15707)

https://i.postimg.cc/j56tXs67/Here-link-Bild.jpg (https://www.excelforum.com/excel-programming-vba-macros/343845-docking-project-explorer-vertically.html#post4545938) or https://i.postimg.cc/WzngMQb7/Here-Excel-forum-colors.jpg (https://www.excelforum.com/excel-programming-vba-macros/343845-docking-project-explorer-vertically.html#post4545938) or https://i.postimg.cc/Y2f6Kmfm/Here-Excel-fox-colors.jpg (https://excelfox.com/forum/showthread.php/2345-Appendix-Thread-(-Codes-for-other-Threads-HTML-Tables-etc-)?p=15706&viewfull=1#post15706)

DocAElstein
10-24-2021, 12:46 PM
Spare Post

DocAElstein
10-24-2021, 10:19 PM
https://i.postimg.cc/tCYHrddF/blowup.gif (https://eileenslounge.com/viewtopic.php?p=289088#p289088)< --- click Here, ( there)

( Gifs are Coutesy of eileenslounge.com, here--->https://i.postimg.cc/21F3MhPL/evilgrin.gif (https://eileenslounge.com/viewtopic.php?p=289082#p289082) )

DocAElstein
10-24-2021, 10:19 PM
Spare Post ( link to here is https://www.excelfox.com/forum/showthread.php/2910-Testing-and-making-announcments?p=21942&viewfull=1#post21942 )




First fuckin around ........





For PQ questions: https://www.excelfox.com/forum/forumdisplay.php/26-Power-Query-Power-Pivot-and-Power-BI
https://i.postimg.cc/MKCSDpzt/fox.gif (https://postimages.org/)https://i.postimg.cc/RZ7TDgxy/satan2.jpg (https://postimages.org/)


<marquee>
https://i.postimg.cc/RZ7TDgxy/satan2.jpg :cool: https://i.postimg.cc/tCYHrddF/blowup.gif (https://www.excelfox.com/forum/forumdisplay.php/26-Power-Query-Power-Pivot-and-Power-BI)< --- click Here, ( there) ....... or go https://i.postimg.cc/GhGBWB0s/here-Excel-fox-colors-ohne-rand-Eileen.jpg (https://www.excelfox.com/forum/forumdisplay.php/26-Power-Query-Power-Pivot-and-Power-BI) 51115112
</marquee>



:):cool:

my favourate


Fuck Bollox Wank




5111
5112

DocAElstein
10-24-2021, 10:19 PM
Spare Post

DocAElstein
10-24-2021, 10:19 PM
Spare Post

DocAElstein
11-11-2021, 09:44 PM
In support of this post
https://excelfox.com/forum/showthread.php/2769-P2P-Cloud-DVR-remote-Access-via-a-(remote)-PC-Using-Guarding-Vision-PC-Client-Software?p=15907#post15907 https://excelfox.com/forum/showthread.php/2769-P2P-Cloud-DVR-remote-Access-via-a-(remote)-PC-Using-Guarding-Vision-PC-Client-Software?p=15907#post15907






#_ Standard Device Selection (Selected by Default) ( Default standard device selected on/by opening software: Device )
A Default device type has been opened/selected automatically
( #_ A “Standard device” could be any directly / locally connected device so can include our PC LAN Access )
What all the current literature does not explain very well is that, by default, the Guarding Vision has one Device type by default selected / highlighted in brown,
https://i.postimg.cc/vH04cL3V/Device-Management-Device-Device-Type-Device.jpg

________Device Managemant
_ Device


_Device Type


_#_Device__




The viewing on a computer via Guarding Vision Software, of a camera , or cameras, which are connected to the DVR can be done at any subsequent time via the uppermost small View tab,
https://i.postimg.cc/SK2nSyVY/View-Main-View-first-use.jpg

View



_#_Main View______

,( but note that after the first time of taking this action , an extra larger Main View main tab will appear and from then on it is always there , https://i.postimg.cc/rp5GgCWp/New-Main-View-tab-appears-after-first-use-of-View.jpg )

_#_Main View_






_#_Device ___________




_#_Device _( Local )____




_#_Device _( Local )____


_#_Device _( Local )____


_#_ Cloud P2P Device ___




________Device Managemant
_ Device


_Device Type


_#_Device ___________


_#_Upgrade Server _____


_#_ Cloud P2P Device ____





________Device Managemant
_ Device


_Device Type


_#_Device ___________


_#_Upgrade Server _____


_#_ Cloud P2P Device ____




_______Register_______






_#_Control Panel______Device Management__ Device


_Device Type______________


__#_Device ____________


_ _#_Upgrade Server _____


_#_ Cloud P2P Device _____


__+_Add New Device Type ___





_#_Control Panel______Device Management__ Device


_Device Type______________


_#_Device _____________


_ _#_Upgrade Server _____


__+_Add New Device Type ___

DocAElstein
11-11-2021, 09:44 PM
Spare Post

DocAElstein
11-11-2021, 09:44 PM
Spare Post

DocAElstein
11-11-2021, 09:44 PM
Spare Post

DocAElstein
11-12-2021, 12:06 PM
Spare Post

DocAElstein
11-12-2021, 12:06 PM
Notes in suppport of this post
https://excelfox.com/forum/showthread.php/2769-P2P-Cloud-DVR-remote-Access-via-a-(remote)-PC-Using-Guarding-Vision-PC-Client-Software?p=15907&viewfull=1#post15907 https://excelfox.com/forum/showthread.php/2769-P2P-Cloud-DVR-remote-Access-via-a-(remote)-PC-Using-Guarding-Vision-PC-Client-Software?p=15907&viewfull=1#post15907

######## .....
####### ....
####### ...
###### ..
######### .

AliceBlue #### AliceBlue
Azure #### Azure
Honeydew##### Honeydew

#########



Just a quick clarify on that last stuff:

_1st username password pair_________________ 2nd username password pair
__ Monitor __________Computer________________________________ Computer
__ DVR---Monitor______DVR-modem/router-Computer___________________ DVR-modem---Internet(P2P)-----modem-Computer
__HDMI or VGA _________local__________________________________re mote
Cable connection____LAN (Ethernet cable) __________( computer can be physically a large distance away from DVR )
_______________________WLAN_______________________ _______ world wide web Internet

DocAElstein
11-12-2021, 12:06 PM
Spare Post

DocAElstein
11-12-2021, 12:06 PM
Spare Post

DocAElstein
01-26-2022, 05:39 PM
Sub DarkBlue()
Dim ItBe As String
Let ItBe = DarkBlue
End Sub


'Converts the specified text with the VBE Color (Black, Blue or Green) using BB code
Private Function BBColor(ByVal Color As Long, ByVal Text As String) As String
Dim Msg As String
Msg = "' http://services.runescape.com/m=forum/forums.ws?278,279,877,64690220
'Msg = Msg & Choose(Color, "black", "blue", "darkgreen") & "]"
Msg = Msg & Choose(Color, "blue", "blue", "darkgreen") & "]" ' Custom Colors Wonk
Msg = Msg & Text
Msg = Msg & ""
BBColor = Msg
End Function[/color]







Sub Blueviolet()
Dim ItBe As String
Let ItBe = Blueviolet
End Sub

'Converts the specified text with the VBE Color (Black, Blue or Green) using BB code
Private Function BBColor(ByVal Color As Long, ByVal Text As String) As String
Dim Msg As String
Msg = "' http://services.runescape.com/m=forum/forums.ws?278,279,877,64690220
'Msg = Msg & Choose(Color, "black", "blue", "darkgreen") & "]"
Msg = Msg & Choose(Color, "blue", "blueviolet", "darkgreen") & "]" ' Custom Colors Wonk
Msg = Msg & Text
Msg = Msg & ""
BBColor = Msg
End Function[/color]


3822

DocAElstein
01-26-2022, 05:39 PM
Spare Post

DocAElstein
01-26-2022, 05:39 PM
Spare Post

DocAElstein
01-26-2022, 05:39 PM
Spare Post

DocAElstein
02-09-2022, 03:08 PM
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

DocAElstein
02-09-2022, 03:08 PM
Spare Post

DocAElstein
02-09-2022, 03:08 PM
Spare Post

DocAElstein
02-09-2022, 03:08 PM
Spare Post

DocAElstein
02-14-2022, 02:10 PM
Test Burgandy

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

PurplePurple
PurplePurple
MaroonMaroon
MaroonMaroon
BurgundyBurgundy
Windows10Windows10
color:#A82D00 $NFS





<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>


'Sub Makro9BBBurgundy() ' ' https://excelfox.com/forum/showthread.php/2417-Test-BB-Code-Highlighting-and-Colors?p=16370#post16370
' With Selection
' .Font.Color = 1704076
' .Text = " " & .Text & " "
' .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 = "C[/B]001A""] "
Text2 = " [/color]"
[color=blueviolet]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

DocAElstein
02-14-2022, 02:10 PM
Spare Post

DocAElstein
02-14-2022, 02:10 PM
Spare Post

DocAElstein
02-14-2022, 02:10 PM
Spare Post

DocAElstein
10-03-2022, 12:46 PM
Test

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
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


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
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.php?p=299529#p299529
https://i.postimg.cc/mDvfF9HP/Stuarts-In-German.jpg
https://i.postimg.cc/mDvfF9HP/Stuarts-In-German.jpg (https://postimages.org/)


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


' https://eileenslounge.com/viewtopic.php?p=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

DocAElstein
10-03-2022, 12:46 PM
Spare Post

DocAElstein
10-03-2022, 12:46 PM
Spare Post

DocAElstein
10-03-2022, 12:46 PM
Spare Post