Microsoft VBA
Microsoft Excel VBA Training Course Manchester/UK Wide
| 11-12/07/2012 | Manchester City Centre-64 Bridge Street,M3 3BN | £295*+VAT | |
|
Or Call
0161 408 0435
|
|||
|
* Prices discounted until 30/07/2012. |
|||
Microsoft Excel is an first-class and widely used tool but only a few use it to its full potential. Some work on Excel can involve time consuming, tedious and repetitive tasks. These tasks can be repetitively copying & pasting, formatting and even making simple and complex calculations.
By learning to write Excel VBA code, these tasks can be performed quickly and accurately. The result is increased efficiency, performance & productivity which means less time & cost performing these repetitive tasks.
This 2 day Excel VBA course is for experienced Excel users wanting to automate repetitive tasks by applying the Visual Basic for Applications (VBA) programming language.
Course delegates must have completed Excel Advanced level training or have equivalent experience prior to attending this training course.
| Getting Started Introducing Visual Basic for Applications Recording, Running & Saving a Macro Understanding the Development Environment Understanding Macro Security Procedures and Functions Creating a Standard Module Creating a Sub Procedure Creating a Function Procedure Working with the Code Editor Using Message Boxes Using Input Boxes Using Expressions, Variables, and Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Working with Variable Scope Using Intrinsic Functions Understanding Constants Declaring and Using Object Variables Understanding Objects Understanding Objects Understanding Collections Using the Object Browser Working with Object Methods & Properties |
Controlling Program Execution Using the If...End If Decision Structures Using the Select Case...End Select Structure Using the Do...Loop Structure Using the For...To...Next Structure Using the For Each...Next Structure Working with Forms and Controls Understanding UserForms Using the Toolbox Working with UserForm Properties, Events, and Methods Understanding Controls Setting Control Properties in the Properties Window Adding Code to Controls Launching a Form in Code Debugging Code Understanding Errors Using Debugging Tools Setting Breakpoints Stepping through Code Using Break Mode during Run mode Determining the Value of Expressions Handling Errors Understanding Error Handling Understanding VBA’s Error Trapping Options Trapping Errors with the On Error Statement Understanding the Err Object Writing an Error-Handling Routine Working with Inline Error Handling |
Our mission is to ensure that every delegate benefits from a training experience that meets their personal requirements and learning objectives. If you feel that the learning objectives have not been satisfactorily attained, we will offer a full refund of course fees.
We also aim to provide our training at a very competitive price. If you are quoted a more competitive price for a similar course from any another training provider, you should contact us or call 0161 408 0435 and we will provide a matching or better quote so you will still benefit from our mamy years of experience and personal service.
