by Tim Miles | Released November 2012 | ISBN: 00005CWORKS

This course introduces you to Excel macro programming using Microsoft's Visual Basic for Application (VBA). The overall focus of this course is to teach you proper Visual Basic programming techniques along with an understanding of Excel's object structure. Other topics in this course include; recording macros, programming basics, proper variable declaration, Visual Basic functions, control structure use, looping, and Userform creation. The final section deals with the debugging tools included in the Microsoft VBA editor and methods on how to effectively use them. Show and hide more

1. Introduction
   • Introduction 00:02:28
2. Macro Development Basics
   • Displaying the Developer Tab 00:09:02
   • Setting Macro Trust within Excel 2010 00:03:50
   • Recording and Running a Macro 00:07:41
   • Examining the VBA Editor 00:38:09
3. VBA Programming Fundamentals
   • Reviewing the Excel 2010 Object Model 00:08:57
   • Understanding Functions and Procedures 00:10:50
   • Understanding Variables and Scope 00:35:17
   • Commenting Your Code 00:03:18
   • Creating Constants 00:05:49
   • Understanding Arguments 00:09:04
4. Working with Control Structures
   • Using If/Then/Else 00:08:01
   • Understanding Logical Operators 00:05:33
   • Creating a Select/Case Statement 00:12:11
   • Creating For/Next Loops 00:11:41
   • Creating Do Loops 00:04:51
   • Creating While/Wend Loops 00:09:29
5. Using VBA Functions
   • Viewing the Object Browser 00:09:28
   • Using the InputBox() Function 00:08:23
   • Understanding the MsgBox() Function 00:16:44
   • Using String Functions 00:15:46
   • Using Date Functions 00:13:04
6. Creating UserForms
   • Designing a Form 00:01:46
   • Understanding Different Controls 00:07:58
   • Working with Form Properties 00:30:43
7. Debugging Techniques
   • Understand the Difference Between Syntax and Logic Errors 00:12:17
   • Using Breakpoints 00:05:43
   • Stepping Through Your Macro 00:02:53
   • Creating Watches 00:04:27
   • Adding Error Traps 00:15:31
8. Conclusion
   • Conclusion 00:03:49
Show and hide more