Examples Of Vba Constants
Some examples of VBA constants, useful when developing programs / add-ins.
' Using a double line when creating a string in code, just type vbDoubleLine
Public Const vbDoubleLine = vbNewLine & vbNewLine
' Using Named Colours for set colour schemes
Note that the colour values are Longs
' ## Colour Constants
Public Enum RGBLongColour
rgbExcelGreen = 4551200
rgbWordBlue = 9522462
rgbOutlookBlue = 11956254
rgbPowerPointRed = 4551200
End Enum
' ## Example
Sub SelectionFill()
Selection.Interior.Color = rgbExcelGreen
End Sub