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