View Single Post
Old 12-08-2017, 05:57 AM   #8
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 12,178
Thanks: 57
Thanked 1,127 Times in 1,029 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Declaring adn defininf public variables

"Dim" is shorter, but for a class module it is all you need in the declaration area. In ANY area, actually, since "Public" in a class module is close to totally meaningless. Just for snorts and giggles look up the "Friend" declaration, which is a strange little category that isn't quite public but isn't quite private either.

Actually, the only time I ever used "Private" was when I built event code and the wizard declared the entry point that way.
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote