Examples Of Vba Constants

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

Twitter Facebook LinkedIn

Leave a Comment