PrintDURATION: 2 days
|TIME: 09:30 to 16:30 GMT|
This course is currently only available for a group of delegates (6+). Please contact us for further details.
Automate repetitive work in Microsoft Excel by creating VBA code (Macro's) to do the work for you. This is a highly regarded course.
Our Microsoft Excel VBA course has been specifically designed for the advanced Excel user who wishes to make use of the more powerful facilities of MS Excel made available from VBA. This course explores VBA language and delegates will develop a small project to ensure that future editing, amending, updating and data extractions can be carried out with the minimum of effort. The course is aimed at those with little or no previous programming background, although experienced programmers wishing to learn VBA will find it a quick and valuable introduction to the language. Previous experience of recording Excel macros is desirable though not essential. Throughout the course the theme of adopting good programming practices will be encouraged.
You want to learn how to create and edit macro’s using Excel VBA programming techniques to automate repetitive tasks. Also, you have no Excel VBA programming experience and want to learn useful industry standard techniques.
Onsite: £2000+VAT for up to six delegates on the same course.
To create and edit VBA code to automate elements of Microsoft Excel.
By the end of this level you will be able to:
What is a Macro? – Recording & Running a Macro – Relative References
Assigning a Macro to a Button or a Drawn Object on a Sheet – Assigning a Macro to a Button on a Toolbar
Visual Basic Editor – Project Explorer – Procedures; Inserting Comments – Printing a Visual Basic Module
Aesthetic improvements – Increasing speed
Structuring an application – Identifying Modules and procedures – Writing and testing tight and concise VBA code – Adopting good programming practices
Collecting user input – Verifying success of each procedure – Understanding an application’s requirements
Cells & Range Method; Flexible Ranges – Virtual Worksheets; Range Contents
Activating a Workbook & Worksheet – This Workbook
Controlling Objects with their Properties – Performing Actions with Methods – Performing Multiple Actions on an Object
Variables and associated Data Types – Object Variables
Conditional & Looping Control Structures – Non-Structured Statements – Sub Procedures
Adding Worksheet Controls – Worksheet Control Properties
Using Drop Down Lists
Errors, Break Mode; Instant Watch – Stepping & Error Handling
User Defined Functions
Save VBA projects