Excel Macros & VBA

Course Description

Being able to create macros and VBA routines changes your attitude to Excel from 'can the program do this?'to 'this is what I need to do, how can I go about it?' Creating macros can extend the functionality of Excel, allow users of VBA to create their own custom Excel functions and reduce work which normally takes several minutes or longer down to a single button click.

As VBA is now the standard programming language within Microsoft applications and also the applications of several other sofware manufacturers, a knowledge of Excel VBA programming can easily be extended to cope with other programs.

This course represents an excellent introduction to programming as the sofware itself writes much of the program code. This one-day course provides enough grounding for the delegate to write useful macros and also acts as a solid basis for further learning.

Course requirements - Delegates should be fully conversant with Excel and other windows applications but need not have learnt any programming before, although obviously the course is also useful for programmers in other programming languages who wish to learn VBA.

Course Outline

	Point and click macros Starting and stopping the macro recorder - naming macros - attaching to toolbar and on-sheet buttons and menus - creating a macro library - Runtime errors.
	Script editing Reading a simple script - making changes - header and footer - annotations - copying and pasting - syntax errors and error messages - WITH and END WITH - How VBA handles formatting instructions - simplifying and rationalising a macro written by the macro recorder.
	Creating functions User-defined functions - advantages - using variables - function generator - calculations in functions - using Excel funtions in VBA.
	Programming Dialogs: Creating a 'Milestone' dialog box - using a built-in dialog Conditional branching: creating an OK/Cancel dialog - using IF...THEN...ENDIF. Loops: FOR...NEXT, WHILE...WEND. Moving data: INPUTBOX - cell VALUE property - using variables - the OFFSET statement. VBA Syntax: Collections, objects, properties and methods. Advanced Dialogs: Creating a custom dialog box Error trapping: The ON ERROR statement - Labels - GO TO statement Using Subroutines: Calling a subroutine from within a subroutine.
	VBA in other applications Discussions: MS Office including Access. Non-Microsoft e.g. CorelDraw.

Contact us for Last minute offers on this course!

Excel Macros & VBA

Name:*

Contact Number:*

E-mail Address:

Type Your Message:

* This course can be tailored to meet your exact requirement!

* One-to-One Excel Macros & VBA courses available!

* Group Excel Macros & VBA courses available at discount prices!

[Back to list]