Excel VBA (2-days)
Sponsored links
Objectives: After completing this course, you will know how to: Use Visual Basic for Applications terminology, start Visual Basic Editor, and work with object properties, methods, and events. Manipulate data by declaring variables and procedures of correct scope to be used when and where you need them. Use decision structures to perform decision tasks and loop structures to perform repetitive tasks. Add a user form to your project, add controls on it, handle events associate with form controls, and validate data entry on forms. Identify errors in code, use the debugging tools, and write error-handling code to trap errors.
Prerequisites: This is a generic course and is suitable for users of any version of Microsoft Excel VBA
Target Audience: Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code.
| Delivery: |
|
| Category: |
Further Details
Course Content:
Visual Basic For Applications Overview
The VBA Editor
Program Structure
Customising The VBA environment
Recording and Running Procedures
Naming and Recording Procedures
Controlling Reference Type
Assigning Procedures
Viewing and Editing Procedures
Reading Visual Basic Code
Editing Visual Basic Code
VBA Project Properties
Working with Visual Basic Code
Variables
Sub Procedures
User Defined Functions
Objects, Properties and Collections
Controlling Objects using Properties
Performing actions with Methods
Object Collections and Variables
User Input, Control and Looping
User Input
Control Structures
Looping
Debugging and Error Handling
Compile Errors
Run-time Errors
Logical Errors Debugging Code
Customising the User Interface
Worksheet Forms
Custom Dialog Boxes
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.
