Hello TheIrishThug,

Unfortunately VBA is not a true object oriented language like C++. A
VBA object does not inherit all the properities from a particular class
when it is created. Programmers who use other OOLs that start to learn
VB or VBA often assume that a Class is a Class. A Class object in VB or
VBA is more like Java and nothing like a C or C++ class. I would suggest
you read up on VB classes to gain a better understanding of their
function and design. Wish I could be more help, but it isn't as simple
as your example.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=496534