24/05/2018, 16:05
Phụ lục 2
Language Element Description Abs Function Returns the absolute value of a number. ...
| Language Element | Description |
| Abs Function | Returns the absolute value of a number. |
| Array Function | Returns a Variant containing an array. |
| Asc Function | Returns the ANSI character code corresponding to the first letter in a string. |
| Atn Function | Returns the arctangent of a number. |
| CBool Function | Returns an expression that has been converted to a Variant of subtype Boolean. |
| CByte Function | Returns an expression that has been converted to a Variant of subtype Byte. |
| CCur Function | Returns an expression that has been converted to a Variant of subtype Currency. |
| CDate Function | Returns an expression that has been converted to a Variant of subtype Date. |
| CDbl Function | Returns an expression that has been converted to a Variant of subtype Double. |
| Chr Function | Returns the character associated with the specified ANSI character code. |
| CInt Function | Returns an expression that has been converted to a Variant of subtype Integer. |
| CLng Function | Returns an expression that has been converted to a Variant of subtype Long. |
| Cos Function | Returns the cosine of an angle. |
| CreateObject Function | Creates and returns a reference to an Automation object. |
| CSng Function | Returns an expression that has been converted to a Variant of subtype Single. |
| CStr Function | Returns an expression that has been converted to a Variant of subtype String. |
| Date Function | Returns the current system date. |
| DateAdd Function | Returns a date to which a specified time interval has been added. |
| DateD if f Function | Returns the number of intervals between two dates. |
| DatePart Function | Returns the specified part of a given date. |
| DateSerial Function | Returns a Variant of subtype Date for a specified year, month, and day. |
| DateValue Function | Returns a Variant of subtype Date. |
| Day Function | Returns a whole number between 1 and 31, inclusive, representing the day of the month. |
| Eval Function | Evaluates an expression and returns the result. |
| Exp Function | Returns e (the base of natural logarithms) raised to a power. |
| Filter Function | Returns a zero-based array containing subset of a string array based on a specified filter criteria. |
| Fix Function | Returns the integer portion of a number. |
| FormatCurrency Function | Returns an expression formatted as a currency value using the currency symbol defined in the system control panel. |
| FormatDateTime Function | Returns an expression formatted as a date or time. |
| FormatNumber Function | Returns an expression formatted as a number. |
| FormatPercent Function | Returns an expression formatted as a percentage (multiplied by 100) with a trailing % character. |
| GetLocale Function | Returns the current locale ID value. |
| GetObject Function | Returns a reference to an Automation object from a file. |
| GetRef Function | Returns a reference to a procedure that can be bound to an event. |
| Hex Function | Returns a string representing the hexadecimal value of a number. |
| Hour Function | Returns a whole number between 0 and 23, inclusive, representing the hour of the day. |
| InputBox Function | Displays a prompt in a dialog box, waits for the user to input text or click a button, and returns the contents of the text box. |
| InStr Function | Returns the position of the first occurrence of one string within another. |
| InStrRev Function | Returns the position of an occurrence of one string within another, from the end of string. |
| Int Function | Returns the integer portion of a number. |
| IsArray Function | Returns a Boolean value indicating whether a variable is an array. |
| IsDate Function | Returns a Boolean value indicating whether an expression can be converted to a date. |
| IsEmpty Function | Returns a Boolean value indicating whether a variable has been initialized. |
| IsNull Function | Returns a Boolean value that indicates whether an expression contains no valid data (Null). |
| IsNumeric Function | Returns a Boolean value indicating whether an expression can be evaluated as a number. |
| IsObject Function | Returns a Boolean value indicating whether an expression references a valid Automation object. |
| Join Function | Returns a string created by joining a number of substrings contained in an array. |
| LBound Function | Returns the smallest available subscript for the indicated dimension of an array. |
| LCase Function | Returns a string that has been converted to lowercase. |
| Left Function | Returns a specified number of characters from the left side of a string. |
| Len Function | Returns the number of characters in a string or the number of bytes required to store a variable. |
| LoadPicture Function | Returns a picture object. Available only on 32-bit platforms. |
| Log Function | Returns the natural logarithm of a number. |
| LTrim Function | Returns a copy of a string without leading spaces. |
| Mid Function | Returns a specified number of characters from a string. |
| Minute Function | Returns a whole number between 0 and 59, inclusive, representing the minute of the hour. |
| Month Function | Returns a whole number between 1 and 12, inclusive, representing the month of the year. |
| MonthName Function | Returns a string indicating the specified month. |
| MsgBox Function | Displays a message in a dialog box, waits for the user to click a button, and returns a value indicating which button the user clicked. |
| Now Function | Returns the current date and time according to the setting of your computer's system date and time. |
| Oct Function | Returns a string representing the octal value of a number. |
| Replace Function | Returns a string in which a specified substring has been replaced with another substring a specified number of times. |
| RGB Function | Returns a whole number representing an RGB color value. |
| Right Function | Returns a specified number of characters from the right side of a string. |
| Rnd Function | Returns a random number. |
| Round Function | Returns a number rounded to a specified number of decimal places. |
| RTrim Function | Returns a copy of a string without trailing spaces. |
| ScriptEngine Function | Returns a string representing the scripting language in use. |
| ScriptEngineBuildVersion Function | Returns the build version number of the scripting engine in use. |
| ScriptEngineMajorVersion Function | Returns the major version number of the scripting engine in use. |
| ScriptEngineMinorVersion Function | Returns the minor version number of the scripting engine in use. |
| Second Function | Returns a whole number between 0 and 59, inclusive, representing the second of the minute. |
| SetLocale Function | Sets the global locale and returns the previous locale. |
| Sgn Function | Returns an integer indicating the sign of a number. |
| Sin Function | Returns the sine of an angle. |
| Space Function | Returns a string consisting of the specified number of spaces. |
| Split Function | Returns a zero-based, one-dimensional array containing a specified number of substrings. |
| Sqr Function | Returns the square root of a number. |
| StrComp Function | Returns a value indicating the result of a string comparison. |
| String Function | Returns a repeating character string of the length specified. |
| StrReverse Function | Returns a string in which the character order of a specified string is reversed. |
| Tan Function | Returns the tangent of an angle. |
| Time Function | Returns a Variant of subtype Date indicating the current system time. |
| Timer Function | Returns the number of seconds that have elapsed since 12:00 AM (midnight). |
| TimeSerial Function | Returns a Variant of subtype Date containing the time for a specific hour, minute, and second. |
| TimeValue Function | Returns a Variant of subtype Date containing the time. |
| Trim Function | Returns a copy of a string without leading or trailing spaces. |
| TypeName Function | Returns a string that provides Variant subtype information about a variable. |
| UBound Function | Returns the largest available subscript for the indicated dimension of an array. |
| UCase Function | Returns a string that has been converted to uppercase. |
| VarType Function | Returns a value indicating the subtype of a variable. |
| Weekday Function | Returns a whole number representing the day of the week. |
| WeekdayName Function | Returns a string indicating the specified day of the week. |
| Year Function | Returns a whole number representing the year. |
