185 Madison Ave. at 34th St., Suite 1104, New York, NY 10016 • 212-684-5151
Microsoft Excel VBA 2010 Level 2
Microsoft Excel VBA 2010 Level 2

Price: $345.00

Course Code: VN | Hours: 8

Microsoft Excel VBA Training Class Outline - Level 2

Students will build on the basic macro building skills acquired in Microsoft Excel VBA Training 2010 Level 1 to achieve a more advanced understanding and expertise in using macros in Excel.

Upon successful completion of this course, students will be able to:

  • navigate a workbook using offsets, range names, and variables
  • analyze data using looping structures, in combination with if and case statements
  • create user interface structures to capture multiple variable inputs
  • control the lifetime and scope of variables
  • create automated event processes
  • create automation to handle unforeseen errors and events

Prerequisites:

Students are recommended to take the following courses or possess equivalent knowledge:

Related Classes:

See Also:

Microsoft Excel VBA Training Outline - VBA Level 2

Lesson 1: Navigating a Worksheet with VBA

        • Topic 1A: Hard Coding Ranges
        • Topic 1B: Offset Statement (Recording with Relative Reference)
        • Topic 1C: Using Names Ranges as Bookmarks

Lesson 2: Analyzing Data with Looping Structures and Decision Making Code

        • Topic 2A: Do While/Until Loop
        • Topic 2B: For Each Next Loop
        • Topic 2C: Nested Loops
        • Topic 2D: If Statement versus IIF Function
        • Topic 2E: Nested If Statement
        • Topic 2F: And & Or Statements
        • Topic 2G: Case Statement

Lesson 3: Using Variables

        • Topic 3A: The Option Explicit Statement
        • Topic 3B: Declaring Variables and Data Types
        • Topic 3C: Defining Variables
        • Topic 3D: Input Boxes
        • Topic 3E: Understanding Scope and Lifetime of Variables

Lesson 4: Using a User Form to Capture Variable Inputs

        • Topic 4A: Toolbox
        • Topic 4B: Option Groups
        • Topic 4C: Text Boxes and Labels
        • Topic 4D: Combo Boxes
        • Topic 4E: Command Buttons
        • Topic 4F: CBF (Code Begind the Form)

Lesson 5: Error Trapping

        • Topic 5A: Handling Errors versus Debugging
        • Topic 5B: Error Properties
        • Topic 5C: On Error Statement
        • Topic 5D: Go To Statement
        • Topic 5E: Line Names
        • Topic 5F: Exit Sub Statement
        • Topic 5G: Message Box Button Values
        • Topic 5H: Capturing a Response

Lesson 6: Finishing Touches

        • Topic 5A: Controlling Application Settings
        • Topic 5B: Streamlining Code
        • Topic 5C: Commenting Code as Documentation
        • Topic 5D: Set Up and Auto Launch Event
        • Topic 5E: Security (Password Protect Code Modules)