Follow Us :

Excel 2003 VBA

Course_Reference: 
DEX03VBA
Manufacturer: 
0
Training_Provider: 
9
Summary: 

In Excel 2003: Introduction to VBA you apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks you learned in Excel 2003: Level 1, Level 2 and Level 3.

PreRequisites: 

To ensure your success, we recommend you first take the Excel 2003: Level 2 course or have proven equivalent knowledge.

Audience: 

Students looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. In addition, students who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data

Objectives: 

After completing this workshop, students will be able to:

  • develop macros.
  • format worksheets.
  • create an interactive worksheet.
  • work with multiple worksheets.
  • perform calculations.

Visual Basic Editor

  • Visual Basic for Applications
  • Object Programming
  • The Object Browser

Programming basics

  • Data
  • 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

Description: 

In Excel 2003: Introduction to VBA you apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks you learned in Excel 2003: Level 1, Level 2 and Level 3. You will use VBA to create macros for automating repetitive tasks in Excel 2003.

Keywords: 
Excel 2003,Microsoft Excel,develop macros,format worksheets,create user-interactive macros,multiple worksheets

Software Vendor

IT Technical

Business Skills