Excel VBA Constant

This post will guide you how to declare a Constant and assign a value to it in MS excel VBA. The constant cannot be changed while the code is running or the program will ends up with an error. Syntax Const  <constant_name> As <Data type> = <Constant_value> Data types The data types contains Byte, Boolean,… read more »