Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Class Module & Module
hello all
I have a class module that have a function "Function CALCULATE_ALL()". it is possible to call it from another function in the module. i´ve tried the tradicional method call CALCULATE_ALL and it gives me an error..it doesn´t recognize it... i already tried the "Public Function CALCULATE_ALL" and i doesn´t works either....it is possible to invoce a function that is in a class_module from the module |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Class Module & Module
Roedd <<Liedson31 wedi ysgrifennu:
I have a class module that have a function "Function CALCULATE_ALL()". it is possible to call it from another function in the module. i´ve tried the tradicional method call CALCULATE_ALL and it gives me an error..it doesn´t recognize it... i already tried the "Public Function CALCULATE_ALL" and i doesn´t works either....it is possible to invoce a function that is in a class_module from the module You need first to create an instance of your class. Then you can call its methods: Dim objInstance as new MyClassModule 'or whatever your class is called. objInstance.CALCULATE_ALL -- Rob http://www.asta51.dsl.pipex.com/webcam/ This message is copyright Robert Bruce and intended for distribution only via NNTP. Dissemination via third party Web forums with the exception of Google Groups and Microsoft Communities is strictly prohibited and may result in legal action. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
Class module | Excel Programming | |||
let and get in class module | Excel Programming | |||
Class module | Excel Programming | |||
Variable from a sheet module in a class module in XL XP | Excel Programming |