Prev: Evaluate problem
Next: Alterations/corrections on userform
From: Mathieu936 on 31 May 2010 10:52
Hi!

I need to create a function that I will use in a worksheet. However,
I need to create it in a worksheet code (not in a separate module, but
in the "Microsoft Excel Objects").

I know it works for a macro, but not for a function. I tried to call
my function with "private function", "public function", but it doesn't
work.

Thanks for your help guys!

Mathieu
From: Harald Staff on 31 May 2010 12:41
Hi Mathieu

Why on earth do you "need to create it in a worksheet code, not in a
separate module" ? Insert a regular module and write your function, end
users don't care where or how functions are written.

HTH. Best wishes Harald

"Mathieu936" <mathieu936(a)gmail.com> wrote in message
news:be516a8c-8cf1-4b67-a7cc-8b6404799681(a)c11g2000vbe.googlegroups.com...
> Hi!
>
> I need to create a function that I will use in a worksheet. However,
> I need to create it in a worksheet code (not in a separate module, but
> in the "Microsoft Excel Objects").
>
> I know it works for a macro, but not for a function. I tried to call
> my function with "private function", "public function", but it doesn't
> work.
>
> Thanks for your help guys!
>
> Mathieu

From: Wouter HM on 31 May 2010 14:38
Hi Mathieu

If you put the line below in the separate module your users will not
find the function in the list of t category User Defined

Option Private Module.


HTH,

Wouter
From: Mathieu936 on 1 Jun 2010 13:09
I want to include the functions in the worksheet code because I have
to copy the worksheet, and I don't want to copy a module with it.
That's the only reason.
 | 
Pages: 1
Prev: Evaluate problem
Next: Alterations/corrections on userform