Microsoft Excel Vba Programming

Course suitable for:
This programme is for you if you already have a thorough understanding of Excel formulae and functions and may already use some Visual Basic programming, but now you are looking for a more professional result using Excel. This programme has been specially designed for advanced users who want to exploit the more powerful features of Excel made available by VBA.
In this programme, you will explore the VBA language and you will be encouraged to write programs to ensure that future editing, amending, and updating can be carried out with the minimum of effort. This is a generic programme and is suitable for users of any version of Excel.
Introduction to macros
-What is a macro?
-Recording and running a macro
-Relative and absolute macros
-Assigning a macro to a button on a worksheet or toolbar
-Button image editor
Editing macros
-The Visual Basic editor
-The project explorer
-The code window
-Procedures
-Inserting comments
-Printing a Visual Basic module
The range object
-What is the range object?
-The cells and range properties
-Flexible ranges
-Range contents
Workbooks and worksheets
-Activating a workbook and worksheet
-This workbook
Objects, properties and methods
-Controlling objects with their properties
-Performing actions with methods
-Performing multiple actions on an object
Variables and constants
-Control structures
-Conditional control structures
-Looping control structures
-Sub-proceduresControls and dialogue boxes
-Built-in dialogue boxes
-Pre-defined dialogue boxes
Storing information
-The Windows registry
-Settings files
Toolbars and display
-About toolbars and menus
-Attaching toolbars to workbooks
-Saving more than one toolbar configuration
-Customised toolbars
-Display techniques
Debugging and error trapping
-What are errors?
-Types of error
-Break mode
-Instant watch
-Stepping through code
-Error handling
Worksheet and workbook events
-Function procedures
-User-defined functions
Add-in applications
-What is an add-in?
-Creating an add-in
-Converting an add-in to a workbook
Review of Programme
Other Recommended Programmes
-Financial Modelling with Microsoft Excel
-One-to-one coaching is available upon request