| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
No you cannot, not in VBA, the UDF has to be in the standard code module.
You can call a class from within the UDF, but not directly as the UDF. -- __________________________________ HTH Bob "Leo" <(E-Mail Removed)> wrote in message news  3A0FC3E-6D59-4454-9BCF-(E-Mail Removed)...> Dear Experts, > I recently became interested in style of using Class Modules. > I need to know if we can use Class Modules to creat User Defined > Functions?(functions that is useable in Excel sheet like a normal > worksheet > function) > if yes, please explain how, and show a simple sample. > thanks in advance. > -- > Thans & Best regards > Leo, InfoSeeker |
|
|
|
|
|||
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| running a Sub in a class module from a functionin a general module | Paul | Microsoft Access Form Coding | 2 | 9th Feb 2010 02:25 AM |
| Difference between Form's Class Module and Class Module | tobesurveyor via AccessMonster.com | Microsoft Access VBA Modules | 4 | 14th Apr 2006 01:08 PM |
| Convert Class Module to Standard Module | =?Utf-8?B?TXVycA==?= | Microsoft Access VBA Modules | 2 | 26th Apr 2005 06:33 AM |
| Class module creating OLEObject | Erich Neuwirth | Microsoft Excel Programming | 0 | 11th Aug 2004 12:43 PM |
| VB hang when opening a class module (or form module) | Antoine | Microsoft Access | 1 | 7th Mar 2004 12:20 AM |
