Constants can be declared on one line if separated by commas

 

Const Age As Integer = 25, City As String = "Denver", PayCheck As Currency = 350

Sub severalConst()
   MsgBox Age
   MsgBox City
   MsgBox PayCheck

End Sub

Related examples in the same category

1.	When declaring a constant, you can use any one of the following data types: Boolean, Byte, Integer, Long, Currency, Single, Double, Date, String, or Variant
2.	To make a constant available within a single procedure, you declare it at the procedure level
3.	Working with Date type value Constants
4.	Use a constant in all the procedures of a module, use the Private keyword in front of the Const statement
5.	Make a constant available to all modules in your application, use the Public keyword in front of the Const statement.
6.	Working with Symbolic Constants
7.	use a Constant to store the PI
8.	Working with pre-defined Constant

Constants can be declared on one line if separated by commas : Const « Language Basics « VBA / Excel / Access / Word

Related examples in the same category