class modules beginner

[mark]

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

 

[Chip Pearson]

Mark,

You should see the Intellisense dropdown list of properties and
methods for your class module. Ensure that you don't have a
compile error elsewhere in the code. This sometimes prevents the
list from being properly displayed.

You can have exactly one class per class module. You cannot have
more than one class per class module, and the name of the class
is the name of the module.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[mark]

Thanks Chip.

I went and tried it again, and sure enough, it was visible
as you said that it should be. I don't know what was
causing it not to be before.

Oh well.
Thanks,
Mark