Premium Only Content

Excel VBA: Adjust Fill Color of WordArt with a Macro
Feb 15, 2018 Excel Charts
Find out how you can use Excel Macros to control the fill color of Wordart in VBA. In this specific case we'd like to show percentage completion as WordArt and control the amount of the fill color based on the actual percentage. If we have 50%, only half of the 50% word will be highlighted.
This video is more than using Excel VBA to control word art. I'll show you how you can find the right syntax, even when the macro recorder doesn't work and doesn't pick up the right code for you. I'll show you how to use the VBA object library to find the correct syntax and how to use Excel's event procedures to connect the macro to your cell value.
➹ ➹ Excel VBA Course ➹ ➹
If you'd like to learn more and become more comfortable with VBA, check out my complete course here: https://courses.xelplus.com/p/excel-vba-excel-macros
🡻 Download the workbook here 🡻
http://www.xelplus.com/excel-vba-wordart-fill-with-macros/
★★ Links to related videos: ★★
Video #1 using bar-in-bar chart: https://youtu.be/6iZT74sKi50
★ My Online Excel Courses ★
Courses ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
-
28:26
Producer Michael
19 hours agoIS THIS MY MOST CRAZY PURCHASE YET?!
2.37K -
23:21
marcushouse
7 hours ago $0.29 earnedStarship Flight When!? Yea, a LOT Just Happened!
1.24K1 -
23:48
Jasmin Laine
16 hours ago“We Reject Demographic Change”—Carney’s Comment BLOWS UP as Poilievre Drops the Hammer
2.7K19 -
LIVE
BEK TV
23 hours agoTrent Loos in the Morning 7/23/2025
216 watching -
12:48
Degenerate Jay
14 hours ago $0.81 earnedUbisoft Hates Game Preservation
7.75K5 -
9:33
The Art of Improvement
20 hours ago $1.50 earnedHow to Bounce Back from Hard Times
9.03K4 -
4:53
The Official Steve Harvey
1 day ago $0.77 earnedNo Such Thing as Luck — Just God’s Grace
8.29K3 -
6:16
GBGunsRumble
20 hours agoGBGuns @ Alabama Arsenal Czech Weapons CSV-9
7.49K -
9:06
MattMorseTV
1 day ago $13.51 earnedTrump wants to END THE FED.
62K99 -
2:05:18
MG Show
20 hours agoBreaking: Ukrainian Whistleblower Letter to DNI Gabbard Exposes Biden Corruption
23.5K19