032. How to show Percentage Project Completion with Word Art and VBA Macro
The goal of this tutorial is How to show the Percentage Project Completion with Word Art and VBA Macro. I explain you how to can find the right VBA syntax using the macro recorder. Based on this, we will build a small macro to fill a WordArt based on a percentage completion
Links:
if statement: • 016. Practical use of the IF statemen...
Link to workbook: https://mega.nz/file/vKRxUIxa#9jO9xDq...
link to previous lesson on filling a bar within a bar without VBA:
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.
Channel content: Excel, excel tutorial, Microsoft excel, learn excel, how to use excel, excel basics, basic excel, ms excel, office 365, excel for dummies, excel functions, learn excel basics, microsoft excel for beginners, excel course, Mr Excel, excel help, microsoft excel tutorial, excel tricks, excel tips, excel guide, how to in excel, tricks in excel, tips and tricks, pivots tables, excel formulas, advanced techniques for excel.
#Excel #MsExcel #Chart