List of available events

A

alafarm

Across office applications VBA, I always have a heck of a time finding the
available events for a given object (Word's Userform_Inialize, Outlook's
Item_Read, etc.). If they are in the VBA Editor's Object Browser, I guess I'm
just not seeing them.

Can someone tell me where one looks to find a list of all available events
for whichever object I'm working with.
 
G

George Lee

There are probably no fewer than four ways to find these events.

The Object browser. Yes, they’re there. Search for the type of object. For
example, within Word, search for ‘application’ in the object browser and the
list area shows all the properties, methods, and events. The events look like
little lightning bolts. Not all objects have events.

VBA Editor. After declaring and setting the object, select the object type
from the top left downdown menu, then look at the top right dropdown list.
This shows all the available events for the object. In addition, if you
select an event, it even pastes the code in the editor for you.

MSDN.microsoft.com Google or search it for the object and events. This is
the definitive source so it’s going to be there.

Help files. Office 2003 installed help files as CHMs. The Word one is called
VBAWD10.chm. They stopped making these but if they’re still on your computer,
use them. I wish they would make them again. I don’t know why but I find
using MSDN as an online reference annoying.
 
A

alafarm

Great. I appreciate it.

George Lee said:
There are probably no fewer than four ways to find these events.

The Object browser. Yes, they’re there. Search for the type of object. For
example, within Word, search for ‘application’ in the object browser and the
list area shows all the properties, methods, and events. The events look like
little lightning bolts. Not all objects have events.

VBA Editor. After declaring and setting the object, select the object type
from the top left downdown menu, then look at the top right dropdown list.
This shows all the available events for the object. In addition, if you
select an event, it even pastes the code in the editor for you.

MSDN.microsoft.com Google or search it for the object and events. This is
the definitive source so it’s going to be there.

Help files. Office 2003 installed help files as CHMs. The Word one is called
VBAWD10.chm. They stopped making these but if they’re still on your computer,
use them. I wish they would make them again. I don’t know why but I find
using MSDN as an online reference annoying.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top