ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Call Private Function from ThisWorkbook module (https://www.excelbanter.com/excel-programming/292497-call-private-function-thisworkbook-module.html)

Bob Phillips[_6_]

Call Private Function from ThisWorkbook module
 
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.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Beto" wrote in message
...
Hi,

Is it possible to call a Private Function, which resides in a normal
module, from the ThisWorkbook module?

If it can be done, How?

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.




Bob Phillips[_6_]

Call Private Function from ThisWorkbook module
 
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" wrote in message
...
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.




Beto[_3_]

Call Private Function from ThisWorkbook module
 
Hi,

Is it possible to call a Private Function, which resides in a normal
module, from the ThisWorkbook module?

If it can be done, How?

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.


Beto[_3_]

Call Private Function from ThisWorkbook module
 
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.



All times are GMT +1. The time now is 07:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com