Microsoft VBA Macro Excel Training Course
VBA (Visual Basic for Applications) is the programming language of Excel (and other Office programs), which specifically allow you to automate your repetitive tasks in Excel by writing so called macros.
Upon successful completion of this 3-day hands-on training course, students will be able to:
• Record and edit macros
• Use the Visual Basic Editor
• Create sub and function procedures
• Understand objects, properties, methods and events
• Explore the Excel object hierarchy and use the Object Browser
• Work with variables and understand data types
• Use intrinsic functions
• Work with control-of-flow structures
• Design UserForms and work with controls
• Control PivotTables programmatically
• Use debugging tools
• Add error handling to code