Enhance VBA with Windows API functions such as to prompt for a folder or to wait for an external program to finish.
Create custom ribbons.
Create your own objects by use of classes and benefit from ease of code reuse.
Create advanced dialog boxes.
Learn conventions and good design for ease of understanding and reliability.
Discover lots of miscellaneous useful instructions and features.

Digitally sign projects

• Digitally sign your projects so that they run without prompts.
• Send multiple Outlook emails without prompts.
• Become a Trusted Source.
• Completely remove macros from a file.

Use Windows API

• Prompt user for a folder.
• Detect a toolbar button click while the user holds the Shift key down.
• Display a message box modelessly.
• Play sounds.

Discover more about forms and controls

• Link text box to spin button.
• Create a modeless UserForm that allows the user to work in a sheet and return to the form.
• Display progress bar.
• Use a Calendar control.
• Play sounds.

Protect application from corruption

• Make an application completely user-bullet-proof.
• Replace the standard Excel menu bar.
• Hide and lock toolbars.
• Use Public variables as storage.
• Compile macros.
• Prevent cut and paste.
• Disable shortcut keys.

Employ user-defined data types

• Create multiple field variables.
• Use enumerated constants.

Build reusable libraries with classes

• Discover the benefit of classes for faster, more reliable application development.
• Create a class to read and write text files.
• Define an Application event that applies to all workbooks.

Create a Windows help file

• Create a Help file with Contents and Index.
• Make Help context-sensitive for your functions and dialog boxes.

Have macro place controls on a worksheet

• Put check boxes against each creditor row in a worksheet
• Discover how to use OLE Objects.

Discover yet more event procedures

• Create event procedure to replace frozen panes after drag of PivotTable fields.
• Make PivotTables refresh on save or print.
• And more.

Learn more debugging techniques

• View the Locals and Call Stack windows.
• Print to Immediate window.

Write code to edit code

• Automate changes to macros.

Learn various useful macros

• Add data labels to charts.
• Synchronise sheets.
• Use SendKeys when all else fails.
• Place combo boxes and text boxes onto a toolbar and program them.
• And more.

Design well

• Know the optimal structure and size for modules and procedures.
• Apply naming conventions.
• Use data types carefully.
• Create pseudocode.

Prerequisites

• Excel users wanting to complete their VBA knowledge and productively write maintainable and robust applications.
• This is an advanced-level course suitable for those who have attended our two-day Macros next step course, or are competent in its agenda items.

• Be assured the advice you get is well-proven and utilised.
• Feel free to ask questions.
• Get time away from the office and constant interruptions.
• Enjoy a friendly environment where you don’t feel you’re holding others up.
• Instantly apply what you’ve learned on return to work.