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
-
1:19:51
Bright Insight
16 hours agoRare ‘UNKNOWN METAL’ Discovered in Egyptian Stone Box!?
93.8K159 -
9:52
Tundra Tactical
22 hours ago $0.07 earnedIsrael Takes the Party Back to 1989!
2.33K6 -
19:26
Cody and Kellie
3 hours agoHot Springs Bathhouse: A Relaxing Retreat
4.44K1 -
9:02
Dr. Nick Zyrowski
12 hours agoIntermittent Fasting Linked To Cardiovascular Death? New Study
2.25K9 -
10:40
Bearing
2 hours agoKamala Harris CRINGE Ads Review | "Be A Man, Vote For A Woman"
2.45K17 -
20:12
Danny Haiphong
11 hours agoNasrallah is GONE: Israel’s SHOCKING Beirut Strike Stuns Hezbollah, All Out War Next?
3.23K12 -
46:14
Squaring The Circle, A Randall Carlson Podcast
1 day ago#021 Hyper Velocity Impacts and Human Civilization Cosmic Encounters of the Holocene Pt 2
4.48K14 -
53:52
hickok45
6 hours agoSunday Shoot-a-Round # 248
3.2K14 -
5:05
Colion Noir
17 hours agoKamala Harris Fought The Supreme Court To Prevent Citizens From Owning Handguns
9.95K15 -
18:52
Bright Insight
17 hours agoThe Great Pyramid HIDDEN Chamber is Now a Conspiracy
172K107