If I write

Private Function myFunct() As Long
....
End Function

Sub mySub()

I = myFunct()

....

End Sub

everything is OK. However, suppose I wish to put myFunct() in a separate
module. Then
it fails because the compiler can't find it. If myFunct() was in a DLL I
could use Declare
to tell the compiler about it, but that seems to work only for DLLs.

How can I get around this? Or, must all functions used in a module be
defined in it?


TIA

Ed

Hello Ed

Private Function can be called from the same module, so pls change
Private to Public.
Or you can omit to write "Public", in this case, that UDF would be
treated as a Public Function.
(Note:Public Function should be placed in standard module)


Code:
--------------------

Public Function myFunct() As Long

--------------------



---
Message posted from http://www.ExcelForum.com/

Colo,
Thanks! I thought I'd tried that, but I now see that it works.

Ed


"Colo >" <<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello Ed
>
> Private Function can be called from the same module, so pls change
> Private to Public.
> Or you can omit to write "Public", in this case, that UDF would be
> treated as a Public Function.
> (Note:Public Function should be placed in standard module)
>
>
> Code:
> --------------------
>
> Public Function myFunct() As Long
>
> --------------------
>
>
>
>