Is there any point in declaring a local Sub variable with Private in any case?
No. Although Private works too. Public declarations inside a non-global sub are actually treated as Private.
To avoid that contradiction, I always declare local variables using Dim.
The Sub declaration on the other hand could be Public or Private (by default).
For clarity I always specify Private Sub or Public Sub.
By the way, it is extremely easy to tests these things oneself.
Edit: AS
@LucaMs pointed out. If you don't specify Public or Private for a Sub, the default is Public.
Good to know, although I always specify it.