I did read up! I got that idea off a microsoft page on this website.
And if anyone else is reading this then I forgot the "set" command in my
code. It should have been:

private sub Class_Initialize
set super = new ClassA
end sub


"NickHK" wrote:

I think you need to read up on how Implements/Interface/classes work.
Chack the help for the Implements key word.

NickHK

"Blue Aardvark" wrote in message
...
Hello

Classes are a real pain in vba. But you could try doing something like
this.
Lets say you want Class B to extend Class A. In the class B code write:

Implements ClassA

private super as ClassA

private sub Class_Initialize
super = new ClassA
end sub

So now classB has an internal copy of ClassA inside it and so you can make
references to that. Eg: super.print( )

(in theory it should work, but as I'm currently stuck on interfaces too
then
I may not be the best person for advice!!)