Naming class modules in Excel 2002

  • Thread starter Thread starter bryan
  • Start date Start date
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
 
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".
 

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

Help w/ Class to get app-wide Wkb.Open event? 5
Workbook Deactivate Event 1
Using Events with the Application Object & XL 2003 13
Excel Add-In to catch application events 1
Object class in Excel VBA 1
Trying to learn custom event handling for class modules. 3
Public Variables, Class Modules and Standard Modules 2
Class Modules and Userforms 3

Back
Top