Excel VBA Programming

Course Description

Students will learn the skills and concepts necessary to programme using VBA.

Course Content

Lesson 1: Visual Basic Editor
Visual Basic for Applications
Object Programming
The Object Browser

Lesson 2: Programming Basics
Data Basics
Scope of Variables
Scope of Procedures

Lesson 3: Control Structures
Design Structures
Loop Structures

Lesson 4: Custom Dialog Boxes
User Forms
Events

Lesson 5: Debugging and Error Handling
Errors
Debugging
Error Handling


pdf Printable course details

Prerequisites

Excel Level 3

or equivalent knowledge.

Course Duration

7.5 hours

Study Methods Available

Individual Tuition

Group Training

Distance Learning

Prices

Distance Learning price
  £85  
  Paypal logo  

For other prices, please contact us.

Follow-on Courses

Access

All Courses

Click here to see all our courses.

Further Information

Enquiry Form

OCR
  Cisco

Sage

CompTIA logo

   BCS logo
ECDL logo
 MCP logo

     Adobe logo