View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mark mark is offline
external usenet poster
 
Posts: 196
Default class modules beginner

Hi.

I've just started to work with writing class modules.

It seems that when a class is first defined, after
dimensioning an object in that class, and setting the
object to a New member of the class, the class's
properties and methods are not available like this:

dim objClass as clsTest
set objClass = New clsTest
objClass.DoSomething

I'm saying that after typing the objClass. , there is no
list of properties and methods to choose from... in order
to use them, you have to know what they are, or go look.

Yet, when the newly defined class is exported to a file,
and then imported to another VBA application, the methods
and properties do become selectable.

Is this normal? Or is there something that I am not doing
which would make them available in the first setting.

Also, it seems that each newly defined class needs to have
it's own class module. Is this correct? Or can multiple
classes be defined in a single class module in a way that
I am not seeing?

Thanks.
Mark