Microsoft Excel specialists

Excel training courses

See dates of all courses
Contact us

  


Related Courses
Macros introduction
Macros next step
Speed up with macros ?introduction 1-day


  WHAT YOU GET

Course manual
& Excel files

20  minutes’
hotline time

Excel expertise
28 years’
specialisation

Macro-writing courses

Macros advanced

     Duration: 1 day  
     Format: Fully hands-on  
   Arrival and refreshments: 8:45am  
   Start 9:00am  
   Finish: 4:30pm  

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.

  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

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

  LEARN IN A POSITIVE ENVIRONMENT
 
  • 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.

Presenters

AbleOwl has a number of different presenters, all of whom are Excel specialists.

See dates of all courses  

  COURSE CANCELLATION POLICY
 
A course booking is considered final when received in writing (online, email, fax or post) by AbleOwl, and can be cancelled up to ten working days before the course. After that, payment is expected in full and no refund will be given. All cancellations must be notified in writing, i.e. post, fax or email. Another delegate may be substituted at any time.