This page has 0 threads | Add post

Event-handling for VBA in other applications

Written by Andy Brown

In this tutorial

MS Word Events
PowerPoint Events
Microsoft Access Events
Microsoft Outlook Events

Although this tutorial is mainly about Excel VBA, we thought we'd briefly show how events work in various other Microsoft Office applications.

MS Word Events

Microsoft Word follows pretty much the same pattern as Microsoft Excel:

You can double-click on ThisDocument to attach code to an event for the document.

The list of events available isn't as rich as it is for Excel:

The list of events doesn't include BeforeClose, for example.

There is a way to create additional events for Word using something called an event sink, but it's scary stuff, and you'll need to understand classes to work out what's going on.

PowerPoint Events

PowerPoint doesn't allow you to attach code to events easily:

There is a presentation open, but you can't see that in Project Explorer.

However, as for Word there is a way to attach code to events for a presentation by creating something called an event sink (see above).

Even if you do create a PowerPoint event sink, you still won't have truly solved the problem, as you still need something to run a macro to create the event sink in the first place!

Microsoft Access Events

The whole of Access form and report design is based around the concept of events:

This diagram shows the events available for a simple label control (a bit of text stuck on a form).

Whereas events in Excel, Word and PowerPoint are optional extras, you won't be able to write VBA code in Access forms or reports without using them all the time.

Microsoft Outlook Events

The events which can occur in an Outlook session are shown below:

Want to create a rule for how new mail should be treated? Don't bother with the Outlook rules - why not create your own in VBA!

Outlook macros are all held in a single file with an .OTM extension.

As the above examples show, handling events in Excel VBA is - as is so often the case - easier than doing the same thing in other MS Office applications.

Previous
tutorial

Loops

Previous
part

Worksheet Events in VBA

Top of page

Next
part

Event Sinks to Capture Application Events

Next
tutorial

Debugging

You can learn more about this topic on the following Wise Owl courses:

This page has 0 threads

Add a new post

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

Visual C# training

Excel training courses

Power Automate training

Power BI / DAX training

Python training courses

SQL training courses

VBA (macros) training

Site map

Terms & Conditions

Online tutorials

Tutorials on VBA

Events