Excel 2010 VBA Programming - CTU Training Solutions

Excel 2010 VBA Programming

This course is designed to give experienced Excel 2010 users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.
Duration: 1 Day   |   Location : Online
Course Prerequisites:
Microsoft Office Excel 2010 Advanced
Request A Quote

Virtual Interactive Lecturer-led Teaching (VILT)

Virtual instruction environments are designed to simulate the traditional classroom or learning experience. Instructor-led training is still the number one delivery method of choice because it allows you to interact and discuss the training material, either individually or in a group setting, and you gain access to expert knowledge from certified instructors. This form of guided learning is impactful and produces positive learning outcomes. Day, evening and Saturday classes are offered.

Course Content

Unit 1: Visual Basic Editor

Topic A: Visual Basic for Applications
A-1: Discussing VBA
A-2: Preparing Excel for VBA
A-3: Examining the VBE window

Topic B: Object programming
B-1: Examining the Properties window
B-2: Changing an object’s properties
B-3: Using code to change object properties
B-4: Using a method
B-5: Associating VBA code with an event
B-6: Executing VBA code by using a button

Topic C: The Object Browser
C-1: Examining the Object Browser
C-2: Searching in the Object Browser

Unit 2: Programming basics

Topic A: Data basics
A-1: Discussing data types and variables
A-2: Declaring and discussing variables
A-3: Using operators
A-4: Using interaction functions

Topic B: Scope of variables
B-1: Understanding procedure- and module-level scope
B-2: Understanding public scope

Topic C: Scope of procedures
C-1: Creating a Sub procedure
C-2: Calling a Sub procedure
C-3: Creating a Function procedure
C-4: Calling a Function procedure

Unit 3: Control structures

Topic A: Decision structures
A-1: Using the If…Then statement
A-2: Using the If…Then…Else statement
A-3: Using the If…Then…ElseIf statement
A-4: Using the Select Case statement

Topic B: Loop structures
B-1: Using the For…Next loop
B-2: Using the For Each…Next loop
B-3: Using the Do While…Loop statement

Unit 4: Custom dialog boxes

Topic A: User forms
A-1: Adding a user form
A-2: Adding controls to a user form

Topic B: Events
B-1: Attaching an event handler to a control
B-2: Validating data by using event handlers

Unit 5: Debugging and error handling

Topic A: Errors
A-1: Discussing the types of errors

Topic B: Debugging
B-1: Discussing debugging tools
B-2: Setting a breakpoint
B-3: Adding a watch expression
B-4: Using Step Into
B-5: Deleting a watch expression
B-6: Working with the Immediate window
B-7: Working with the Locals window

Topic C: Error handling
C-1: Using the On Error GoTo statement
C-2: Using the On Error Resume Next statement

CTU Training Solutions , Updated: April 24th, 2018

Request A Quote

The course information above is subject to change without notification due to market trends in the industry, legislation and/or programme version updates. Terms and Conditions

Open chat
Need Help?
How can we assist you today?