| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating UDF by Class Module (Leo)?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating UDF by Class Module (Leo)?
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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating xy graph charts for algebra class | Excel Discussion (Misc queries) | |||
| CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
| Chart Class Module/follow on question to hyperlink post earlier. | Charts and Charting in Excel | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
Linear Mode
