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".
 
Top