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

See response in .misc.

--
__________________________________
HTH

Bob

"Leo" <(E-Mail Removed)> wrote in message
news:5799F749-4C2E-4BEE-B0BB-(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

A class module is particularly unsuitable for UDFs, because you must
create an instance of a class to use anything contained within the
class, and Excel has no knowledge of what objects may or may not have
been created by VBA at any particular time. As a general rule, UDFs
should be in regular code modules, not class modules. For more info
about class modules, see http://www.cpearson.com/Excel/Classes.aspx.
For more info about UDFs, see
http://www.cpearson.com/Excel/Writin...ionsInVBA.aspx.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Tue, 2 Dec 2008 01:04:05 -0800, Leo <(E-Mail Removed)>
wrote:

>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.