Excel 2010: VBA (Visual Basic) 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.

Visual Basic Editor

·         Visual Basic for Applications

·         Object programming

·         The Object Browser

Programming basics

·         Data basics

·         Scope of variables

·         Scope of procedures

Control structures

·         Decision structures

·         Loop structures

Custom dialog boxes

·         User forms

·         Events

Debugging and error handling

·         Errors

·         Debugging

·         Error handling

Register online.