Calendar Constants
You can replace the actual values anywhere in your code with the following constants:
Constants |
value |
Description |
Vbcalgreg |
0 |
It is noted that the Gregorian calendar is used. |
Vbcalhijri |
1 |
It was pointed out that the Islamic calendar was used. |
Color Constants
You can replace the actual values anywhere in your code with the following constants:
Constants |
value |
Description |
Vbblack |
0x0 |
Black |
vbred |
0xFF |
Red |
Vbgreen |
0xff00 |
Green |
Vbyellow |
0xFFFF |
Yellow |
Vbblue |
0xff0000 |
Blue |
Vbmagenta |
0xff00ff |
Purplish red |
Vbcyan |
0xffff00 |
Cyan |
Vbwhite |
0xFFFFFF |
White |
CALLTYPE constant
You can replace the actual values anywhere in your code with the following constants:
Constants |
value |
Description |
Vbmethod |
1 |
Indicates that a method has been called. |
Vbget |
2 |
Indicates a Property Get procedure. |
Vblet |
4 |
Indicates a Property Let process. |
Vbset |
8 |
Indicates a property Set procedure. |
The following Constants from the Visual Basic for Applications type library definition, which can be used to replace the actual value anywhere in the code:
Comparison constant
Constants |
value |
Description |
Vbusecompareoption |
-1 |
Use the settings for the Option Compare statement to compare. |
Vbbinarycompare |
0 |
Make a binary comparison. |
vbTextCompare |
1 |
Make a comparison of the text. |
Vbdatabasecompare |
2 |
For Microsoft Access (Windows only), for comparisons based on information contained in the database. |
COMPILER constant
Visual Basic for applications defines some that cannot be associated with the #If ... Then A constant used with a #Else instruction. These constants are global in addition to their scope, that is to say, in addition to being applied everywhere in engineering, in terms of functional and #If ... Then. #Else directive defines the same constants.
On the 16-bit development platform, the compilation constants are defined as follows:
Constants |
value |
Description |
Win16 |
True |
Indicates that the development environment is 16 bits. |
Win32 |
False |
Indicates that the development environment is not 32 bits. |
On the 32-bit development platform, the compilation constants are defined as follows:
Constants |
value |
Description |
Vba6 |
True |
Indicates that the development environment is Visual Basic for applications, version 6.0. |
Vba6 |
False |
Indicates that the development environment is not visual Basic for Applications, version 6.0. |
Win16 |
False |
Indicates that the development environment is not 16 bits. |
Win32 |
True |
Indicates that the development environment is 32 bits. |
Mac |
False |
Indicates that the development environment is not Macintosh. |
Win16 |
False |
Indicates that the development environment is not 16-bit. |
Win32 |
False |
Indicates that the development environment is not 32-bit. |
Mac |
True |
Indicates that the development environment is Macintosh. |
AttentionThese constants are provided by Visual Basic, so you cannot define your own constants in any hierarchy with the same name.
DATE constant
You can replace the actual values anywhere in your code with the following constants:
Parameter values
The firstdayofweek parameter has the following values:
Constants |
value |
Description |
Vbusesystem |
0 |
Use the NLS API settings. |
Vbsunday |
1 |
Sunday (default) |
Vbmonday |
2 |
Monday |
Vbtuesday |
3 |
Tuesday |
Vbwednesday |
4 |
Wednesday |
Vbthursday |
5 |
Thursday |
Vbfriday |
6 |
Friday |
Vbsaturday |
7 |
Saturday |
The firstdayofyear parameter has the following values:
constant |
value |
description |
vbusesystem |
0 |
|
Vbusesystemdayofweek |
0 |
|
VbFirstJan1 |
1 | The
|
vbfirstfourdays |
2 |
|
vbfirstfullweek |
3 |
|
return value
Constants |
value |
Description |
Vbsunday |
1 |
Sunday |
Vbmonday |
2 |
Monday |
Vbtuesday |
3 |
Tuesday |
Vbwednesday |
4 |
Wednesday |
Vbthursday |
5 |
Thursday |
Vbfriday |
6 |
Friday |
Vbsaturday |
7 |
Saturday |
Date Format Constants
You can use these constants only if your project has an explicit reference to the corresponding type library that contains the constants definitions.
Constants |
value |
Description |
Vbgeneraldate |
0 |
Displays the date and/or time. For a real number, display the date and time. If you do not have a decimal part, only the date is displayed. If there is no integer part, only the time is displayed. The display of the date and time is determined by the system setting value. |
vbLongDate |
1 |
Displays a date in a long date format specified by the computer locale value. |
Vbshortdate |
2 |
Displays a date in the short date format specified by the computer locale value. |
Vblongtime |
3 |
Displays the time in a long time format specified by the computer locale value. |
vbShortTime |
4 |
Displays the time in a short time format specified by the computer locale value. |
Dir, GetAttr, and SetAttr constants
You can replace the actual values anywhere in your code with the following constants:
Constants |
value |
Description |
Vbnormal |
0 |
Normal (the default values forDir and setattr ) |
vbReadOnly |
1 |
Read-only |
Vbhidden |
2 |
Hidden from |
Vbsystem |
4 |
System files |
VbVolume |
8 |
Volume label |
Vbdirectory |
16 |
Directory or folder |
Vbarchive |
32 |
The file has changed since the last backup |
Vbalias |
64 |
On the Macintosh, the identifier is an alias. |
On the Macintosh, only vbnormal, vbreadonly, vbhidden , and Vbalias are available.
Current 1/2 page
12 Next read the full text