Leverage Excel’s VBA tool for operations, macros, and debugging. Learn to format cells, manage sheets, and utilize FormatConditions object.
Excel’s VBA can be a powerful tool useful for a multitude of purposes if you know how to leverage its capabilities, debug issues, and mitigate for specific limitations. In this introductory course, you’ll begin by using subroutines in VBA to perform operations. You’ll then define functions and reference and edit cell ranges and Excel sheets with VBA. After that, you’ll invoke subroutines with relative cell references, record macros in Excel, and debug macros in VBA. You’ll insert columns and sheets from VBA and format cells based on a condition in VBA both manually and using a FormatConditions object. Finally, you’ll illustrate how clearing formatting using a FormatConditions object will only clear formatting created using a FormatConditions object, not by using if-else conditionals.
This course is 1 hour 55 mins long.
Learn More