Naming class modules in Excel 2002
 

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

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

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

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"bryan" skrev i en meddelelse
om...
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