- Home
- All Courses
- Microsoft Excel
- Introduction to Microsoft Excel Macros / VBA
Curriculum
- 7 Sections
- 31 Lessons
- Lifetime
Expand all sectionsCollapse all sections
- WelcomeHi and welcome to my course on MS Excel macros and VBA.1
- Uses and benefits of macrosExcel Visual Basic for Applications (VBA) is a programming language that can be used to automate tasks and customize the behaviour of Microsoft Excel.5
- Getting to know the macro recorder4
- The VBA language7
- The object browser0
- Controlling the flow of a VBA programThis encompasses different programming constructs or structures that determine how the computer interprets and processes your program statements. For instance, in which order should statements be executed? How many times should statement(s) be executed? In what circumstances should statements be executed?8
- The Visual Basic Editor (VBE)This is the area where you as the developer, write your code. When you use the macro recorder, the code that is automatically generated is also placed here.7