International experts in Excel

Your power-packed agenda  

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 functions

• 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.
• Use the tab key to navigate controls on a sheet.

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

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.

Who should attend:

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