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
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Tutorial: Formulas that you can use to get the value of the last non-empty cell in a range in Excel...
Tutorial: The Present Value (PV) function in Excel will return the current value of an investment.Â...
Macro: This macro will make the text of any selected cell in excel proper case. This means that t...
Tutorial: How to get the decimal part of a number without any rounding in Excel. This tip allows yo...
Tutorial: How to calculate the payment amount for a loan or similar financial instrument that has a ...
Tutorial: Return the largest value from a list, or any of the top values, in Excel. This method use...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)