Public variables, on the other hand, should be used as little as possible.
Agree, but I've never found a good way to pass information to userforms, 'Good' being defined as a straight-forward easily maintainable way