O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Excel 2007 VBA Macro Development

Video Description

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.

Table of Contents

  1. Introduction
    1. Introduction 00:02:43
  2. Understanding the Excel Object Model
    1. Understanding Objects 00:01:51
    2. Referencing Workbooks, Worksheets, and Cells 00:03:07
  3. Creating Recorded Macros
    1. Displaying the Developer Tab 00:02:10
    2. Setting Macro Trust within Excel 00:01:59
    3. Recording a Macro 00:06:40
    4. Running a Macro 00:00:40
    5. Editing a Macro with the Visual Basic Editor 00:03:03
  4. Understanding the Visual Basic Editor
    1. Examining the VBA Editor Menu and Toolbar 00:09:44
    2. Setting VBA Editor Options 00:08:52
    3. Reviewing the Project Explorer 00:01:15
    4. Reviewing the Properties Window 00:03:05
    5. Understanding the Object and Procedure drop-down lists 00:01:17
    6. Viewing the Immediate Window 00:02:36
    7. Viewing the Object Browser 00:05:36
  5. Understanding Programming Basics
    1. Understanding Functions and Procedures 00:05:54
    2. Dimensioning Variables 00:12:27
    3. Understanding Object Variables 00:05:10
    4. Understanding Variables and Scope 00:05:45
    5. Commenting your Code 00:04:53
    6. Creating Constants 00:04:28
    7. Manipulating Data 00:06:33
    8. Understanding Procedure Arguments 00:09:43
  6. Using Visual Basic Functions
    1. Using the InputBox() Function 00:11:23
    2. Understanding the MsgBox() Function 00:10:02
    3. Using String Functions 00:12:07
    4. Using Date Functions 00:11:08
  7. Working with Control Structures
    1. Using If/Then/Else 00:06:42
    2. Creating a Select/Case Statement 00:05:02
    3. Understanding Logical Operators 00:04:30
    4. Creating For/Next Loops 00:06:58
    5. Creating Do Loops 00:06:20
    6. Creating While/Wend Loops 00:05:01
  8. Creating UserForms
    1. Understanding UserForms 00:01:10
    2. Understanding Controls 00:11:28
    3. Setting Control Properties 00:01:06
    4. Referencing Controls in VBA Code 00:02:44
    5. Responding to Events 00:11:16
    6. Creating a function to open a UserForm 00:02:19
    7. Development Tips 00:02:59
  9. Debugging your Macros
    1. Understanding Logic Errors and Syntax Errors 00:04:23
    2. Running your Macro from the VBA Editor 00:01:01
    3. Setting Breakpoints 00:01:35
    4. Stepping Through Your Macro 00:03:44
    5. Creating Watches 00:06:58
    6. Adding Error Trapping 00:11:25
  10. Conclusion
    1. Conclusion 00:03:25