less than 1 minute read
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
Tags: developer
Categories: vba
Updated: November 16, 2018