By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills



Step 164 - Constants - Const SW_SHOW = 1


Constants are variables that can't change.

Usually upper case.

Can't change the value.

Many are already set up in VBA
  • vbCRLF
  • vbLF
  • xlMaximized

    Using the constant value is safer than the actual number because if the value changes in future versions your Macros could break.


    •    Table of Contents | Send us your feedback | © 2025 All Rights Reserved | Edit