Get the Numeric Value of any Constant in VBA

Two simple tricks to get the number value for constants in VBA and Macros for Excel.

Constants in VBA are like variables whose values never change and it is important to be able to get the constant value of a constant without wasting time looking it up or searching for it.

This is especially helpful when you use the macro recorder to generate some code and compare it to your own macros because one version might use the numeric value of the constant and one version might use the name of the constant, and you want to make sure that you can quickly compare the two versions without issue.

Additional Resources

Constants in VBA (msft)

List of Constants in Excel VBA (msft)