Turning Basic Excel into Dynamic Word Art Masterpieces with VBA

Discover the power of VBA in Excel for customizing Word Art! In this easy-to-follow tutorial, we dive into the fascinating world of VBA, specifically focusing on conditionally formatting Word Art. Whether you're working on a project or tracking progress, this video is your go-to guide for visualizing percentages in a creative and clear way.

🔑 Key Highlights:
Explore how to link Word Art to cell values for dynamic updates.
Learn the step-by-step process to manipulate Word Art properties like fill color and gradient using VBA.
Understand the core concepts of VBA – objects, properties, and methods – in a straightforward, practical manner.
Discover how to find the right VBA syntax for your needs, even if you're not a frequent VBA user.

📌 What You'll Learn:

Connecting Word Art to Cell Values: We show you how to make your Word Art reflect changes in cell values, perfect for visually tracking data like project completion percentages.
Manual Formatting vs. VBA: Compare the limitations of manual formatting and the vast possibilities with VBA.
Real-Time Problem Solving: Witness the process of solving a user's query from an Excel forum, providing insights into practical VBA application.
VBA Syntax Discovery: Uncover the methods to determine the right VBA syntax for specific tasks, a valuable skill for any Excel user.
Final Touches with Macro Recorder: Learn how to use the macro recorder effectively to kickstart your VBA coding.

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.

★★ Links to related videos: ★★

🚩Let’s connect on social:

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!

#excel

[vijaysahal]

ms Leila wow you are really great your teaching way is very unique.👍👍👍👍👍👍👍👍👍👍

[gopalakrishnarao]

Once again a Big Salutation to my beloved and beautiful Excel Teacher/Guru, for explaining fantastically with VBA. In every video you are putting your heart & soul, in doing miracles. I am not missing any of your videos. My humble request to you Madam, please start the series VBA. Thanks a lot for doing this with keen interest and with great enthusiasm.

[bricc]

Thank you so much, Leila, for this video. I particularly enjoyed the part where you explain how to use the object library. Grateful for that!

[kumarrakesh]

Hi Laila u r a grt teacher indeed, ur each video teaches new things. Thankx

[andrewmoss]

Another great demonstration of an Excel 'hack', Leila. Really looking forward to the VBA course you are releasing soon!

[ashisbasak]

All your tutorials are great. Thanks Laila

[TheDutchGemini]

Nice idea and well explained.

Colour constants from "VBA.ColorConstants" can be used for 8 basic colours instead of RGB() function, e.g. vbBlack, vbWhite or vbYellow. Preset named RGB colours are available from 'XlRgbColor' enumeration, e.g. rgbBlack.

I recommend using full qualifier to any object to make sure the object is indeed the one intended and not expect Excel to guess for you. In your video you removed 'ActiveSheet' from the 'Shapes' collection however this entails that when Excel triggers the 'Change' procedure, you must be darn sure that the 'Shapes' collection is actually pointing to the proper sheet. In many years of programming VBA I've often encountered code where the author was overconfident about the object's context and did not use the full hierarchy but in practice Excel was addressing an object of the same kind but located elsewhere and the code would fail.

[MySpreadsheetLab]

Nicely done Leila! Great explanation of how your vba works.

[sreckoselendic]

Enjoying all your videos, learning great stuff, and more importantly, using in everyday business :-)

[gohzw]

Thank you so much! Please come up with more videos ! From Singapore

[jayacharya]

That was Great Leila. Love your work and simplicity of explaining things. Thanks for sharing file too..

[BostonRoger]

-removes "proficient" from excel on my resume....

the more I learn the more I realize I know NOTHING about excel lmao. This is amazing.

[abdanomer]

Finally VBA, thank you for sharing 👌🏻

[theenlighteneds]

Thank you for the video and the workbook...

[OzduSoleilDATA]

Oh lord! VBA. Scary. 😱
Brilliant content. 👍

[vikasdsem]

I really like the video. im waiting for the VBA course to out, i really hope it will come soon thank u.
I always learn something new from the ur video

[tarynx]

Such a great tutorial. I was wondering how you would apply conditional formatting to the colour. For instance green for a percentage of 70%-100%. I don't know if that can be done. Appreciate any advice.

[Mvirk]

You are awesome Leila ...I love to watch your videos :)

[robertakwasiadjei]

Hello Leila, you are awesome. Thanks a lot for making a significant change in my career. When is your VBA course coming on.

[vivekmusafir]

Very useful…thank you so much…I have a query though…what if value exceeds 100%…lets say 120%…I am sure entire figure will be filled with Black…what I want is additional information popping up besides the word art stating value exceeded 100%…some sort of alarm/indicator..can be handy if we are measuring expenses against budget. Thank you in advance as I know you’ll come up with solution very soon :-)