| VBA / Excel / Access / Word » Language Basics » Const |
| 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. | Working with Symbolic Constants | ||
| 8. | use a Constant to store the PI | ||
| 9. | Working with pre-defined Constant |