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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.