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
-
55:22
The Rubin Report
1 hour agoTsunami Evacuation Creates Massive Oprah Winfrey Controversy
6.38K2 -
LIVE
The Mel K Show
32 minutes agoMORNINGS WITH MEL K - Signal to Noise: Parasitic Global Governance Agenda 2030 Undeterred & UnAmerican 7-30-25
331 watching -
LIVE
LFA TV
15 hours agoLFA TV ALL DAY STREAM - WEDNESDAY 7/30/25
5,112 watching -
LIVE
The Shannon Joy Show
1 hour ago🔥🔥The Roots Of Technocracy EXPOSED. Dark Enlightenment & The Game B Techno-Beast. Top Experts Patrick Wood, Courtenay Turner & Joe Allen LIVE & Exclusive! 🔥🔥
65 watching -
LIVE
Tudor Dixon
1 hour agoMarsha Blackburn on Ending DEI & Fighting Political Indoctrination | The Tudor Dixon Podcast
86 watching -
DVR
Bannons War Room
5 months agoWarRoom Live
30.5M7.47K -
LIVE
Benny Johnson
1 hour agoD-DAY: BOMBSHELL Release Expected TODAY That Will Change EVERYTHING, Trump Posts Hillary Behind Bars
7,727 watching -
LIVE
JuicyJohns
3 hours ago $1.86 earned🟢#1 REBIRTH PLAYER 10.2+ KD🟢$500 GIVEAWAY
117 watching -
LIVE
Caleb Hammer
3 hours agoShe Came Here To Cancel Me | Financial Audit
106 watching -
LIVE
MYLUNCHBREAK CHANNEL PAGE
2 hours agoExposing It All
645 watching