Naming class modules in Excel 2002

B

bryan

How do you do this???

In VB Help for Excel 2002 under 'Using Events with the Application
Object', it says 'Before you can use events with the Application
object, you must create a new class module and declare an object of
type Application with events. For example, assume that a new class
module is created and called EventClassModule'.

When I do an Insert/Class Module, it's generated with name Class1. How
do I change this to EventClassModule?

Regards,

Bryan
 
B

Ben McBen

Either show the property window (View -> Properties
Window) or right click -> Properties
 
L

Leo Heuser

Bryan

You can do it from the properties window.
The uppermost line with (Name).

If the properties window is not visible, get
it with <F4> or from the menu "View".
 

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

Similar Threads

VSTO C# add in Outlook.Appointment error 0
Help w/ Class to get app-wide Wkb.Open event? 5
Using Events with the Application Object 4
How/where to declare variables shared by objects of a class? 3
Doubleclick event programming 1
class module and encapsulation 2
Using Events with the Application Object 8
Class Modules and Userforms 3

Top