LBound Function
LBound(arrayname[, dimension])
Returns a Long value that represents the smallest subscript for a dimensioned array (arrayname). For multidimensional arrays, the dimension argument can be included to specify which dimension should be used.
LCase Function
LCase(string)
Converts a string to all lowercase characters and returns a new String value.
Left Function
Left(string, length)
Returns a String value length characters long that is taken from the left side of a given string.
Len Function
Len(string | varname)
Returns a Long value that indicates the number of characters in a string or, alternatively, the number of bytes required to store a particular variable (varname).
Let Statement
[Let] varname = expression
Assigns the value of an expression to a variable (varname). The Let keyword is usually omitted and is assumed by Visual Basic.
Line Input # Statement
Line Input #filenumber, varname
Reads a line of data (ending with a carriage return or carriage return-linefeed) from an open disk file corresponding to the filenumber argument. The data is placed in the String or Variant variable specified by varname.
Load Statement
Load object
Loads an object, such as a form or control, into memory.
LoadPicture Function
LoadPicture([stringexpression])
Loads the image specified by the stringexpression argument and returns it. This allows pictures to be loaded in and assigned to a Form's Picture property, a PictureBox control, or an Image control. If no stringexpression argument is given, then LoadPicture returns an empty picture.
LoadResData Function
LoadResData(index, format)
Loads data from the resource (.RES) file with the identifier of the index argument. The format argument specifies the format of the data (1 for cursors, 2 for bitmaps, 3 for icons, 4 for menus, 5 for dialog boxes, 6 for strings, 7 for font directories, 8 for fonts, 9 for accelerator tables, 10 for user-defined resources, 12 for group cursors, and 14 for group icons). The data returned by the LoadResData function can be assigned to a variable or object of the appropriate type.
LoadResPicture Function
LoadResPicture(index, format)
Loads a bitmap, icon, or cursor from the resource (.RES) file with the identifier of the index argument. The format argument specifies the format of the data (0 for bitmaps, 1 for icons, and 2 for cursors). The data returned by the LoadResPicture function can be assigned to an object of the appropriate type.
LoadResString Function
LoadResString(index)
Loads a string from the resource (.RES) file with the identifier of the index argument. The string that is returned can be assigned to a variable of String or Variant data type.
Loc Function
Loc(filenumber)
Returns a Long value that indicates the current byte position within the open file that corresponds to the filenumber argument.
Lock Statement
Lock [#]filenumber[, recordrange]
Prevents another process from accessing all or part of the open file that corresponds to the filenumber argument. The recordrange argument refers to a range of records (or bytes) that are to be locked and should use the syntax:
recnumber | [start] To end
where recnumber is the record number (for Random files) or byte position (for Binary files) where locking should begin. Alternatively, the starting and ending record numbers or bytes to be locked can be specified using the start and end arguments.
LOF Function
LOF(filenumber)
Returns a Boolean value that represents the byte size of the open file that corresponds to the filenumber argument.
Log Function
Log(number)
Returns a Double value that represents the natural logarithm of a specified number.
LSet Statement
LSet stringvar = string
or
LSet varname1 = varname2
In the first syntax, LSet assigns a string value to a String variable (stringvar), left-aligning the string to the String variable. In the second syntax, LSet copies a variable (varname2) from one user-defined type to a variable (varname1) in another user-defined type.
LTrim Function
LTrim(string)
Returns a Variant of subtype String that contains a copy of a given string with any leading spaces removed.
Mid Function
Mid(string, start[, length])
Returns a String value of one or more characters, taken from the String variable specified by the string argument. The start argument specifies the character position within string where the new String is to be obtained, and the optional length argument specifies how many characters are to be taken from string. If no length is specified, then all the characters in string (starting at the position given in the start argument) are used.
Mid Statement
Mid(stringvar, start[, length]) = string
Replaces one or more characters in a String variable (stringvar) with another string. The start argument specifies the character position within stringvar to place the new string, and the optional length argument specifies how many characters of string should be used. If length is omitted, then the entire string is used.
Minute Function
Minute(time)
Returns a Variant of subtype Integer that represents the minute (0-59) of the time value specified by the time argument.
MIRR Function
MIRR(values(), financerate, reinvestrate)
Returns a Double value that represents the modified internal rate of return for an array of values that represent cash flow. The values() array must contain at least one negative value (payment) and one positive value (receipt). The financerate argument specifies the interest rate paid as a cost of financing, and the reinvestrate argument specifies the interest rate received on gains from cash reinvestment.
MkDir Statement
MkDir path
Creates the new directory or folder specified by the path argument.
Month Function
Month(date)
Returns a Variant of subtype Integer that represents the month (1[nd]12) for the date value specified by the date argument.
MsgBox Function
MsgBox(prompt[, buttons][, title][, helpfile, context]
Displays a message in a dialog box with one or more buttons and waits for the user to respond. MsgBox then returns an Integer value that represents the button that was clicked. The prompt argument specifies the message to be displayed in the dialog box, and title specifies an optional caption for the dialog box's title bar. The optional buttons argument specifies which buttons will be displayed. The optional helpfile and context arguments are used to provide context-sensitive Help for the dialog box.
Name Statement
Name oldpathname As newpathname
Renames the file, directory, or folder specified by the oldpathname argument to the name specified by newpathname.
Now Function
Now
Returns a Variant of subtype Date that contains the current system date and time.
NPer Function
NPer(rate, pmt, pv[, fv[, type]])
Returns a Double value that indicates the number of periods for an annuity based on periodic fixed payments (pmt) and a fixed interest rate (rate). The pv argument specifies the present value of a series of payments or receipts. The optional fv argument specifies the future value or cash balance left after the final payment. The optional type argument specifies when payments are due (0 for end of the payment period, the default; 1 for beginning of the payment period).
NPV Function
NPV(rate, values())
Returns a Double value that represents the present value of an investment based on a discount rate (rate) and an array of values that represent cash flow. The values() array must contain at least one negative value (payment) and one positive value (receipt).
No comments:
Post a Comment