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
Смотрите видео Get the Numeric Value for a Constant in VBA - VBA Quickie 9 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь TeachExcel 17 Июнь 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,892 раз и оно понравилось 54 людям.