ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Class Module & Module (https://www.excelbanter.com/excel-programming/331206-class-module-module.html)

Liedson31

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


Robert Bruce[_2_]

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.




All times are GMT +1. The time now is 12:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com