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
-
11:50
Microsoft Excel Full Course
3 years agoExcel 365 Visual Basic Part 27 – Running Macros
63 -
4:54
Tuts4dummies
10 months agoExcel | VBA | How to add chart | part 2
10 -
50:21
Microsoft Excel Full Course
3 years agoExcel 365 Visual Basic Part 26 – Macros
108 -
1:44
ztan1011
3 years agoHighlight selected row or column in Excel VBA
15 -
5:13
Tuts4dummies
10 months agoExcel | VBA | How to Add Chart
283 -
24:45
Microsoft Excel Full Course
3 years agoExcel Visual Basic 365 Part 28 – Macro Examples
119 -
4:34
TECHNOLOGY, TIPS AND TRICK VIDEOS
9 months agoHow to Set the Print Area in Excel
5 -
1:59
Computer Training
2 years ago2018 35 Fill Color for Cells
23 -
21:06
Microsoft Excel Full Course
3 years agoExcel 365 Visual Basic Part 33 – Formatting
99 -
32:01
Microsoft Excel Full Course
3 years agoExcel 365 Visual Basic Part 29 – VB Editor
78