Can someone kindly sell me the trick to call up subroutines (residing in
a general module) to a Class Module.-ie I want to make the call while in
the Class Module.

My cumbersome workaround is to duplicate and paste a copy of the
routine I wish to call in the Class Module. Certainly not pretty.


I do know that Class Module is by definition private but so is the
Userform Module which presents no such problem.

TIA

David


--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=515596

David

call moduleName.MacroName


eg

Call Sheet1.TestMacro1


--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread...hreadid=515596