y, April 12, 2012 6:09 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Call a Function
That helps alot Asa, now I understand why I see that people use classes when
working with Userforms. I can also use them when working with objects such
as charts. As far as what I read online,
www.cimaware.com/resources/article_39.html
>
> http://www.cpearson.com/excel/classes.aspx
>
>
>
> Asa
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Matt
> *Sent:* Wednesday, April 11, 2012 6:21 AM
> *To:
t: Wednesday, April 11, 2012 6:21 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Call a Function
Yes, I moved it to another module and I believe I had an older copy of that
code in a different module as well and that was a problem too.
I've been trying to understand clas
gt; excel-macros@googlegroups.com] *On Behalf Of *Matt
> *Sent:* Tuesday, April 10, 2012 6:03 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Call a Function
>
>
>
> Thanks Asa. Your advice helped! I thought I tried it before but I guess I
> missed
Subject: Re: $$Excel-Macros$$ Call a Function
Thanks Asa. Your advice helped! I thought I tried it before but I guess I
missed something and it works now.
Tx again'
Matt
On Thursday, April 5, 2012 3:27:51 PM UTC-4, tag wrote:
please see...
Sub or Function not defined (Visual
Thanks Asa. Your advice helped! I thought I tried it before but I guess I
missed something and it works now.
Tx again'
Matt
On Thursday, April 5, 2012 3:27:51 PM UTC-4, tag wrote:
>
> please see...
> Sub or Function not defined (Visual Basic)
>
> A *Sub* or *Function* must be defined in o
Is it private function ??
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Matt
Sent: Apr/Fri/2012 12:26
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Call a Function
Hello, I'm trying to call a public function in one module fro
please see...
Sub or Function not defined (Visual Basic)
A *Sub* or *Function* must be defined in order to be called. Possible
causes of this error include:
-
Misspelling the procedure name.
-
Trying to call a procedure from another project without explicitly
adding a reference
Please attach example, to better understand
Chilexcel
2012/4/5 Matt
> Hello, I'm trying to call a public function in one module from another Sub
> procedure in another module and it won't call the the function. I get an
> error that says.."sub function not defined" But when I include the funct
