Visual Basic for Excel
Sponsored links
Those who require the fundamental skills to create useful and powerful VB applications.
Unleash the full power of Microsoft Excel by exploring Visual Basic. This will allow you to create more automated spreadsheets which can cut down on the time it takes users to complete basic but time consuming tasks.
| Delivery: |
|
| Regions: |
|
| Category: |
Further Details
Learning Objectives
By the end of this course you will be able to…
•Work with Command and Function procedures
•Understand Variables
•Work with Objects
•Create User Forms
•Set options within Excel
•Observe event handling codes
•Debug Code
Course Content
•Introduction to the VBA environment
•Command & Function procedures
•Using Variables
•Operators
•Objects
•Collections
•Properties
•Methods
•If…then…else
•Do…loop
•For…next
•Code that repeat’s
•Using VBA to display information
•Reading and setting Excel’s options
•Using Forms
•Event handling code
•User defined menus & toolbars
•Add in Applications
•Breakpoints and watches
•The Immediate Window
This Training Course is taught in classrooms in the following locations:
Leicester
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
