Re: Call Private Function from ThisWorkbook module

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bob Phillips (bob.phillips_at_notheretiscali.co.uk)
Date: 02/25/04 

Date: Wed, 25 Feb 2004 13:36:02 -0000

The way you describe is how you reference a Public function in a class
module, like ThisWorkbok, from another module. 

-- 
HTH
Bob Phillips
    ... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Beto" <beto_z_o.Borra_Esto@hotmail.com> wrote in message
news:c1i6vm$1io3em$1@ID-95421.news.uni-berlin.de...
> Bob Phillips wrote:
>
> > Beto,
> >
> > No, if it's private it means that it doesn't want to be accessible from
> > another module. It needs to be Public for that.
> >
>
> Just what I thought. I was hoping there may be a way to reference the
> module and then the function, sort of like "Module1.Function1". Anyway,
> I already solved my problem with a workaround.
>
> Regards,
> -- 
> Beto
> Reply: Erase between the dot (inclusive) and the @.
> Responder: Borra la frase obvia y el punto previo.
>

Relevant Pages

  • Re: Writing Access functions
    ... passing values by Value or by Reference. ... Public Function NameFromIDAs String ... If you pass a control reference: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Help with VBA code - passing references to sheets?
    ... I'm just going to pass the name of the worksheet as a string and activate it ... "Bob Phillips" wrote: ... Private Sub NewMonthButton_Click ... reference would pass. ...
    (microsoft.public.excel.programming)
  • Re: Dynamically load functions
    ... $includeMap should contain 1 entry for each function I wish to reference, ... Is the function 'call_user_func_array' the actual system function calling routine? ... public function __call{ ...
    (comp.lang.php)
  • Re: Function Warning - Null Reference
    ... Warning 1 Function 'Dec2hms' doesn't return a value on all code paths. ... null reference exception could occur at run time when the result is used. ... Public Function Dec2hmsAs String ... Public Function Dec2hms As String ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Run-time Error 2186
    ... I should also point out that there are other buttons that also reference the ... When I obtain the "Run-time Error 2186" and hit debug, ... Public Function Manufacturer() As String ...
    (microsoft.public.access.forms)