How to call a sub from UserForm Module
 

Suppose I am dwelling in a general module and want to call up
subroutine "Test" located in a Userform1 module, provided the sub i
not qualified PRIVATE, I would use *Call Userform1.Test*

Now, how do I accomplish the same task if the call is made, not from
general module, but from a ClassModule? Call Userform1.Test fails i
this connection.

Thanks for any help.


Myle

--
Myle
-----------------------------------------------------------------------
Myles's Profile: http://www.excelforum.com/member.php...fo&userid=2874
View this thread: http://www.excelforum.com/showthread.php?threadid=52795

How to call a sub from UserForm Module
 

Many thanks Peter for the solution. It's not as straightforward as on
would think, if because the code

Dim c As New Class1
c.try

in the general module is crucial. That is enlightening.

One again, thanks.


Myle

--
Myle
-----------------------------------------------------------------------
Myles's Profile: http://www.excelforum.com/member.php...fo&userid=2874
View this thread: http://www.excelforum.com/showthread.php?threadid=52795