Working with Symbolic Constants : Const « Language Basics « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Language Basics
  3. Const

Working with Symbolic Constants

 
Private Const TAXRATE As Currency = 0.0875
Function TotalAmount(curSaleAmount As Currency)
   TotalAmount = curSaleAmount * TAXRATE
End Function








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.Constants can be declared on one line if separated by commas
7.use a Constant to store the PI
8.Working with pre-defined Constant