VBA: Getting Started with VBA in Excel

Excels 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 youll begin by using subroutines in VBA to perform operations. Youll then define functions and reference and edit cell ranges and Excel sheets with VBA. After that youll invoke subroutines with relative cell references record macros in Excel and debug macros in VBA. Youll insert columns and sheets from VBA and format cells based on a condition in VBA both manually and using a FormatConditions object. Finally youll illustrate how clearing formatting using a FormatConditions object will only clear formatting created using a FormatConditions object not by using if-else conditionals.