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.
|
|
