View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default difference between a private sub and a public function?

Functions are different from Subroutines in that they return something back to
the caller. Subroutines don't return anything.

Functions or subs can be private or public.

If a function or sub is public, then it can be seen by routines in other
modules. If it's private, then that function or sub can't be seen except in
that module.



Dave F wrote:

What's a good explanation of the difference between a private sub and a
public function?

And is there such a thing as a public sub and a private function?

Thanks,

Dave

--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


--

Dave Peterson