Visual Basic for Applications defines constants to simplify your programming. The following constants can be used anywhere in your code in place of the actual values:
Calendar Constants
Color Constants
Comparison Constants
Compiler Constants
Date Constants
Date Format Constants
Dir, GetAttr, and SetAttr Constants
DriveType Constants
File Attribute Constants
File Input/Output Constants
IMEStatus Constants
Keycode Constants
Miscellaneous Constants
MsgBox Constants
QueryClose Constants
Shell Constants
SpecialFolder Constants
StrConv Constants
System Color Constants
Tristate Constants
VarType Constants