RE: $$Excel-Macros$$ Call a Function

2012-04-13 Thread Asa Rossoff
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,

Re: $$Excel-Macros$$ Call a Function

2012-04-12 Thread Matt
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:

RE: $$Excel-Macros$$ Call a Function

2012-04-11 Thread Asa Rossoff
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

Re: $$Excel-Macros$$ Call a Function

2012-04-11 Thread Matt
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

RE: $$Excel-Macros$$ Call a Function

2012-04-10 Thread Asa Rossoff
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

Re: $$Excel-Macros$$ Call a Function

2012-04-10 Thread Matt
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

RE: $$Excel-Macros$$ Call a Function

2012-04-06 Thread Rajan_Verma
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 m

Re: $$Excel-Macros$$ Call a Function

2012-04-05 Thread ChilExcel
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

Re: $$Excel-Macros$$ Call a Function

2012-04-05 Thread ChilExcel
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

$$Excel-Macros$$ Call a Function

2012-04-05 Thread 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 function within the same module, my code works... I can't seem to find the answ