Correct syntax to make Class Function Private yet callable by instances of Class (1 Viewer)

Greetings,

I would like to make a function within a class Private, yet retain ability to call the function via "Me.FuncName" within the class.

At first I thought to change Public to Private for this particular Function in the Class. Other Functions in the class could not call it via "Me.FuncName"

I dropped the Private declariaton and now other functions in the class may call "Me.FuncName", however elsewhere in the program that use instances of this class, I see the Private FuncName showing up, via the VBA AutoComplete assistance.

1) So, is there no need to declare Class Funcs as Public since they show up without?

2) And how to make a Func Private, callable by the class itself only?

mdlueck said:

1) So, is there no need to declare Class Funcs as Public since they show up without?

Click to expand...

Yes it makes no difference but it's always good to be explicit. Functions are Public as default whereas (I believe) variables are Private as default.

mdlueck said:

2) And how to make a Func Private, callable by the class itself only?

Click to expand...

Not possible I'm afraid. VBA doesn't support any other scope declaration keywords. VBA doesn't fully support OOP as well.

vbaInet said:

Not possible I'm afraid. VBA doesn't support any other scope declaration keywords.

Click to expand...

eeewww... That is unfortunate that Private is not supported. I guess I will really discourage direct calling in the comments. (shrug).

In fact I went as far as placing the prefix "Priv_" in the front of the name of the function. That way it is a bit more obvious in the VBA editor which smart guesses what you might be typing.

All you do is simply declare it as Private and don't use the Me. syntax when you call it within the class. Just call it using the function name.