Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 42
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 108
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CLASS MODULE & SIMPLE MODULE FARAZ QURESHI Excel Discussion (Misc queries) 1 September 7th 07 09:32 AM
Class module Chip Pearson Excel Programming 0 January 19th 05 03:01 PM
let and get in class module Doug Glancy Excel Programming 3 June 30th 04 02:30 PM
Class module Mark[_36_] Excel Programming 2 February 17th 04 03:14 PM
Variable from a sheet module in a class module in XL XP hglamy[_2_] Excel Programming 2 October 14th 03 05:48 PM


All times are GMT +1. The time now is 03:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"