Excel VBA Intermediate
- By the end of the course the delegate will be fully competent in the fundamentals of VBA, including working with functions, understanding objects, using expressions, variables and intrinsic functions.
- This includes mastering forms and controls, and building user defined functions.
- There will also be discussion of techniques for improving and optimizing code.
What to expect
- Courses never cancelled .
- Restaurant lunch .
- Last minute rescheduling .
- 24 month delegate support forum .
- Face-to-Face and Online Instructor led .
- And more... .
Upcoming start dates
Choose between 40 start dates
Upcoming start dates
Suitability - Who should attend?
This course is suitable for advanced users of Microsoft Excel looking to further increase their knowledge of VBA.
Training Course Content
Storing information with variables
How and why you should declare variablesDetermining which data type to use
Public v Private scope
Using variables to trap errors
Using the Locals window to observe variables
Creating functions
Writing your own User Defined Functions (UDFs)Working with multiple arguments
Using your function in Excel
Message Boxes and Input Boxes
Displaying a messageAdding a yes / no user choice
Getting feedback from the end user
Handling Errors
Defining VBA's Error Trapping OptionsCapturing Errors with the On Error Statement
Determining the Err Object
Coding an Error-Handling Routine
Using Inline Error Handling
Creating custom dialogue boxes with UserForms
Drawing UserFormsSetting UserForm properties, events and methods
Using text boxes, command buttons, combo boxes and other controls
Formatting controls
Applying code to controls
How to launch a form in code
Expenses
List price £350, promotional rates available. STL are the only company to offer a dynamic pricing and availability model, updated live on our site, daily on this portal. Closed group training options available (at your offices, UK wide/International or our London Venues). Contact us below.
Request information - obligation free
Customer Outreach Award
We believe that it should be easy for you to find and compare training courses.
Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.
Reviews by course attendees
Average rating 4.8
Based on 492 reviews.
Write a review!
Reviews are published according to our review policy.
STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London
STL
Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...
Ads
Most useful topic: VBA