Is there a way in VBA to know about variables that aren't being used?

Question

Is there a tool, method or setting in VBA to warn about variables that have been DIMmed, but aren't being used?

Answer 1

MZ-Tools will search through your code and tell you what is not being used. The version for VBA can be found here.

The specific feature in MZ-Tools that performs what you asking about is Review Source Code:

The Review Source Code feature allows you to review the source code to detect some unused declarations (constants, variables, parameters, procedures, etc.).