How can you get this effect?
Find out how you can use Excel Macros to control the fill color of Word Art in VBA. In this specific case we have a dynamic Word Art which shows a percentage value that is connected to a cell with a formula.
Anytime the cell value is changed, the Word Art should update AND it’s fill color should also adjust based on the percentage value. If we have 50%, only half of the 50% Word Art will be highlighted.
This video is more than just about 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 required 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 get the Word Art to update anytime the cell value changed.
Feel free to Download the Workbook HERE.
Founder of XelPlus and ten-time Microsoft MVP. Leila helps over 500,000 professionals master Excel, Power BI, and data automation through practical, real-world training.
Join the Course
Featured Course
First step to Excel
This course helped me catch up and put it all together
Featured Course
Featured Course
Featured Course
Get it all
My Excel knowledge is improved a lot after the courses. My work is much faster and easier prepared and the presentations are much more appreciated.
Kickstart your week with our free newsletter covering Excel hacks, Power BI tips, and the latest in AI. You get to stay updated and get all the insights you need, delivered straight to your inbox.
You can unsubscribe anytime of course.
