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.