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

Excel VBA Quickie Playlist: https://www.youtube.com/playlist?list=PLxhsXZXQXrUDjjYmKn5Wi3V6dkyjGpV9q
Excel File: https://www.teachexcel.com/excel-tutorial/2451/get-the-numeric-value-of-any-constant-in-vba?src=yt

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/office/vba/language/concepts/getting-started/declaring-constants
List of Constants in Excel VBA (msft): https://docs.microsoft.com/en-us/office/vba/api/Excel.Constants

Excel Courses:
- VBA/Macro Course: https://www.teachexcel.com/vba-course-update.php
- Building Professional Forms: https://www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube_v_Kr6szySbV0g
- Email Course: https://www.teachexcel.com/premium-courses/96/send-emails-from-excel-course?src=youtube_v_Kr6szySbV0g

TeachExcel.com

#msexcel #excelquickie #tutorial

Видео Get the Numeric Value for a Constant in VBA - VBA Quickie 9 канала TeachExcel