Basic Constants/text/sbasic/shared/03040000.xhpPi;Basic constantNull;Basic constantEmpty;Basic constantNothing;Basic constantBasic constant;NothingBasic constant;NullBasic constant;EmptyBasic constant;PiBasic constant;FalseBasic constant;TrueVBA Exclusive constantsBasic ConstantsConstants used in Basic programsBoolean constants
NameTypeValueTrueBoolean1FalseBoolean0
Dim bPositive as BooleanbPositive = TrueMathematical constant
NameTypeValuePiDouble3.14159265358979
Function Rad2Deg( aRad as Double) As Double Rad2Deg = aRad * 180.00 / PiEnd FunctionObject Constants
NameTypeUsageEmptyVariantThe Empty value indicates that the variable is not initialized.NullnullIndicates that the variable does not contain data.NothingObjectAssign the Nothing object to a variable to remove a previous assignment.
SubExampleEmptyDim sVar As Variant sVar = Empty Print IsEmpty(sVar) ' Returns TrueEnd SubSub ExampleNullDim vVar As Variant MsgBox IsNull(vVar)End SubSub ExampleNothingDim oDoc As Object Set oDoc = ThisComponent Print oDoc.Title oDoc = Nothing Print oDoc ‘ ErrorEnd SubAdditional VBA constantsThe following constants are available when VBA compatibility mode is enabled
Named constantHexadecimal (decimal) valueDescriptionvbCr\x0D (13)CR - Carriage returnvbCrLf\x0D\x0A (13 10)CRLF - Carriage return and line feedvbFormFeed\x0c (12)FF - Form feedvbLf\x0A (10)LF - Line feedvbNewLine\x0D\x0A (13 10) for 32-bit Windows\x0A (10) for other 64-bit systemsLF or CRLF vbNullString""Null stringvbTab\x09 (9)HT - Horizontal tabvbVerticalTab \x0B (11)VT - Vertical tab