Question

where there is no difference dim and private in VBA ?​

Answer 1

Explanation:

There is no different between using Dim or Private on a module/class level variable, because they mean the same thing. Inside an actual code block or method, you can't use the private keyword.