Is there anyway to create static methods in VBA Class Modules. By this I
mean methods that can be accessed from outside the Class Module without
making an instance of the object.

As a more concrete example:

I have a class module to hold a Time (a value for hour, minute, and
AM/PM). I declare various variables that are instances of the Time
object. I want to see if one time is before another but I do not
necessarily want to have to create an instance of a Time Object to do
that. (I want to be able to call functions by using Time.x as you can
do in regular Methods).

I know this is possible in the C# and C++ frameworks through the use of
Static Methods. Is it possible in VBA?

Thanks for any help.


---
Message posted from http://www.ExcelForum.com/