Basic Constants

Constants used in Basic programs

Boolean constants

नाम	टाइप	मान
True	Boolean	1
False	Boolean	0

Example:


            Dim bPositive as Boolean
            bPositive = True

Mathematical constant

नाम	टाइप	मान
Pi	Double	3.14159265358979

Example:


            Function Rad2Deg( aRad as Double) As Double
             Rad2Deg = aRad * 180.00 / Pi
            End Function

Object Constants

नाम	टाइप	प्रयोग
Empty	Variant	The Empty value indicates that the variable is not initialized.
Null	null	Indicates that the variable does not contain data.
Nothing	Object	Assign the Nothing object to a variable to remove a previous assignment.

Example:


            SubExampleEmpty
                Dim sVar As Variant
                sVar = Empty
                REM ले सत्य फर्काउदा IsEmpty(sVar) मुद्रण गर्दछ ।
            End Sub
            Sub ExampleNull
                Dim vVar As Variant
                MsgBox IsNull(vVar)
            End Sub
            Sub ExampleNothing
                Dim oDoc As Object
                Set oDoc = ThisComponent
                Print oDoc.Title
                oDoc = Nothing
                Print oDoc ' Error
            End Sub

MsgBox Named Constants

नामाङ्कित अचल	इन्टिजर मान	परिभाषा
MB_OK	0	'ठीक छ' बटन मात्र प्रदर्शन गर्नुहोस्।
MB_OKCANCEL	1	'ठीक छ' र 'रद्द गर्नुहोस्' बटनहरू प्रदर्शन गर्नुहोस्।
MB_ABORTRETRYIGNORE	2	Display Abort, Retry, and Ignore buttons.
MB_YESNOCANCEL	3	'हो', 'होइन' र 'रद्द गर्नुहोस्' बटनहरू प्रदर्शन गर्नुहोस्।
MB_YESNO	4	'हो' र 'होइन' बटनहरू प्रदर्शन गर्नुहोस्।
MB_RETRYCANCEL	5	'पुन: प्रयास गर्नुहोस्' र 'रद्द गर्नुहोस् ' बटनहरू प्रदर्शन गर्नुहोस्।
MB_ICONSTOP	16	Add the Stop icon to the dialog.
MB_ICONQUESTION	32	संवादमा प्रश्न प्रतिमा थप्नुहोस्।
MB_ICONEXCLAMATION	48	Add the Exclamation Point icon to the dialog.
MB_ICONINFORMATION	64	संवादमा सूचना प्रतिमा थप्नुहोस्।
	128	पूर्वनिर्धारित बटनको रूपमा संवादमा पहिलो बटन।
MB_DEFBUTTON2	256	पूर्वनिर्धारित बटनको रूपमा संवादमा दोस्रो बटन।
MB_DEFBUTTON3	512	संवादमा पूर्वनिर्धारित बटनको रूपमा तेस्रो बटन।

GetAttr Named Constants

नामाङ्कित अचल	मान	परिभाषा
ATTR_NORMAL	0	Normal files.
ATTR_READONLY	1	Read-only files.
ATTR_HIDDEN	2	Hidden file
ATTR_SYSTEM	4	प्रणाली फाइल
ATTR_VOLUME	8	Returns the name of the volume
ATTR_DIRECTORY	16	Returns the name of the directory only.
ATTR_ARCHIVE	32	File was changed since last backup (Archive bit).

Data Type Named Constants

TypeName values	Named constant	VarType values	चल प्रकार
…()		8192	Array of variables
Boolean		11	Boolean variable
Byte		17	Byte variable
Date	V_DATE	7	Date variable
Currency	V_CURRENCY	6	Currency variable
Double	V_DOUBLE	5	Double-precision floating-point variable
Error		11	Error type variable
Integer	V_INTEGER	2	Integer variable
Long	V_LONG	3	Long integer variable
Object		9	Object variable
Single	V_SINGLE	4	Single-precision floating-point variable
String	V_STRING	8	String variable
Variant		12	Variant variable (can contain all types specified by the definition)
Empty	V_EMPTY	0	Uninitialized Variant variable
Null	V_NULL	1	वैध डेटा छैन

Additional VBA constants

The following constants are available when VBA compatibility mode is enabled

यस k, कार्य वा वस्तुले प्रयोगयोग्य कार्यक्रम कोडमा एक मोड्युलमा प्रयोग गरिएको Option VBASupport 1 विधानसहितका अगाडि सक्षम गरिएको छ।

VBA Color Named Constants

नामाङ्कित अचल	Red, Green, Blue composition
vbBlack	RGB(0, 0, 0)
vbBlue	RGB(0, 0, 255)
vbCyan	RGB(0, 255, 255)
vbGreen	RGB(0, 255, 0)
vbMagenta	RGB(255, 0, 255)
vbRed	RGB(255, 0, 0)
vbYellow	RGB(255, 255, 0)
vbWhite	RGB(255, 255, 255)

Variable Type Named Constants

नामाङ्कित अचल	Decimal value
vbArray	8192
vbBoolean	11
vbByte	17
vbCurrency	6
vbDataObject	13
vbDate	7
vbDecimal	14
vbDouble	5
vbEmpty	0
vbError	10
vbInteger	2
vbLong	3
vbNull	1
vbObject	9
vbSingle	4
vbString	8
vbUserDefinedType	36
vbVariant	12

FormatDateTime VBA Named Constants

Named Constant	मान	वर्णन
vbGeneralDate	0	Displays a date and/or time as defined in your system's General Date setting. If a date only, no time is displayed; If a time only, no date is displayed.
vbLongDate	1	Display a date using the long date format specified in your computer's regional settings.
vbShortDate	2	Display a date using the short date format specified in your computer's regional settings.
vbLongTime	3	Displays a time as defined in your system's Long Time settings.
vbShortTime	4	Display a time using the 24-hour format (hh:mm).

StrConv VBA Named Constants

रूपान्तरण	मान	वर्णन
vbUpperCase	1	Converts Text characters to uppercase.
vbLowerCase	2	Converts Text characters lowercase.
vbProperCase	3	Converts the first letter of every word in Text to uppercase.
vbWide	4	Converts narrow (half-width) characters in Text to wide (full-width) characters.
vbNarrow	8	Converts wide (full-width) characters in Text to narrow (half-width) characters.
vbKatakana	16	Converts Hiragana characters in Text to Katakana characters.
vbHiragana	32	Converts Katakana characters in Text to Hiragana characters.
vbUnicode	64	Converts Text characters to Unicode characters using the default code page of the system.
vbFromUnicode	128	Converts Text characters from Unicode to the default code page of the system.

WeekDayName VBA Named Constants

मान	VBA Constant	वर्णन
0	vbUseSystemDayOfWeek	Use system locale settings
1	vbSunday	आइतबार (पूर्वनिर्धारित)
2	vbMonday	सोमबार
3	vbTuesday	मंगलबार
4	vbWednesday	बुधबार
5	vbThursday	विहीवार
6	vbFriday	शुक्रबार
7	vbSaturday	शनिबार

Miscellaneous VBA Named Constants

नामाङ्कित अचल	Hexadecimal (decimal) value	वर्णन
vbTrue	-1	Part of vbTriState enumeration.
vbFalse	0	Part of vbTriState enumeration.
vbUseDefault	-2	Part of vbTriState enumeration.
vbCr	\x0D (13)	CR - Carriage return
vbCrLf	\x0D\x0A (13 10)	CRLF - Carriage return and line feed
vbFormFeed	\x0c (12)	FF - Form feed
vbLf	\x0A (10)	LF - Line feed
vbNewLine	\x0D\x0A (13 10) for Windows \x0A (10) for other systems	LF or CRLF
vbNullString	""	Null string
vbTab	\x09 (9)	HT - Horizontal tab
vbVerticalTab	\x0B (11)	VT - Vertical tab