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
Watch video Get the Numeric Value for a Constant in VBA - VBA Quickie 9 online without registration, duration hours minute second in high quality. This video was added by user TeachExcel 17 June 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,892 once and liked it 54 people.