Take this
course

Software Development / Programming Languages

Excel VBA 2010

This course introduces the user to Excel 2010 macro programming using Microsoft’s Visual Basic for Application (VBA).

Description

The overall focus of this course is to teach the user proper Visual Basic programming techniques along with an understanding of Excel’s object structure. Other topics in this course include; proper variable declaration, 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.  


Instructor: Timothy Miles

Full details

Curriculum

  • Introduction
    Introduction
    2:29
  • Macro Development Basics
    Displaying the Developer Tab
    9:03
    Setting Macro Trust within Excel 2010
    3:51
    Recording and Running a Macro
    7:42
    Examining the VBA Editor
    38:10
  • VBA Programming Fundamentals
    Reviewing the Excel 2010 Object Model
    8:57
    Understanding Functions and Procedures
    10:50
    Understanding Variables and Scope
    35:18
    Commenting Your Code
    3:19
    Creating Constants
    5:49
    Understanding Arguments
    9:05
  • Working with Control Structures
    Using If-Then-Else
    8:02
    Understanding Logical Operators
    5:34
    Creating a Select-Case Statement
    12:11
    Creating For-Next Loops
    11:41
    Creating Do Loops
    4:51
    Creating While-Wend Loops
    9:30
  • Using VBA Functions
    Viewing the Object Browser
    9:29
    Using the InputBox Function
    8:23
    Understanding the MsgBox Function
    16:44
    Using String Functions
    15:47
    Using Date Functions
    13:04
  • Creating User Forms
    Designing a Form
    1:46
    Understanding Different Controls
    7:59
    Working with Form Properties
    30:43
  • Debugging Techniques
    Understanding the Difference Between Syntax and Logic Errors
    3:49
    Using Breakpoints
    5:44
    Stepping Through Your Macro
    2:54
    Creating Watches
    4:28
    Adding Error Traps
    15:32
  • Conclusion
    Course Recap
    3:50

Skills

  • Microsoft Visual Basic for Applications (VBA)
  • Microsoft Excel

Similar Courses

More Courses by this Instructor