Get the Numeric Value for a Constant in VBA - VBA Quickie 9

Excel VBA Quickie Playlist:    • Excel VBA Quickies  
Excel File: https://www.teachexcel.com/excel-tuto...

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): https://docs.microsoft.com/en-us/offi...
List of Constants in Excel VBA (msft): https://docs.microsoft.com/en-us/offi...

Excel Courses:
VBA/Macro Course: https://www.teachexcel.com/vba-course...
Building Professional Forms: https://www.teachexcel.com/premium-co...
Email Course: https://www.teachexcel.com/premium-co...

TeachExcel.com

#msexcel #excelquickie #tutorial