Alphabetical N - Z

NAMERenames an existing file or directory.
NOTThe logical 'NOT' operator (Boolean).
NOWReturns the current system date and time (Date).
NPERReturns the number of periods for an investment (Double).
NPVReturns the present value of a series of unequal cash flows at regular intervals (Double).
OBJPTRReturns a LongPtr on a 64 bit version and a Long on a 32 bit version.
OCTReturns the number converted to octal (Variant).
OPENOpens a text file or CSV file.
ORThe logical 'OR' operator (Boolean).
PARTITIONReturns a string indicating which particular range it falls into (String).
PMTReturns the amount of principal and interest paid in a given period in a series of equal cash flows at regular intervals (Double).
PPMTReturns the amount of principal paid in a given period in a series of equal cash flows at regular intervals (Double).
PRINTWrites display-formatted data to a sequential file.
PUTWrites data from a record into a text file.
PVReturns the present value of an annuity (Double).
QBCOLORReturns the RGB colour corresponding to the specified colour number (Long).
RAISEEVENTFires an event declared at module level within a class, form or document.
RANDOMIZEInitialises the random number generator.
RATEReturns the interest rate for a series of equal cash flows at regular intervals (Double).
REDIMInitialises and resizes a dynamic array.
REMSpecifies a single line of comments.
REPLACEReturns the text string with a number of characters replaced (String).
RESETCloses all files open with the Open statement.
RGBReturns the number representing an RGB colour value (Long).
RIGHTReturns a number of characters from the right of a string (String).
RMDIRRemoves an existing directory.
RNDReturns a random number between 0 and 1 (Single).
ROUNDReturns a number rounded to a given number of decimal places (Double).
RSETRight aligns a string within a string variable.
RTRIMReturns the text string without trailing spaces (String).
SAVEPICTURESaves a graphic image from an objects Picture or Image property to a file.
SAVESETTINGWrites to the registry and saves a section or key in the registry.
SECONDReturns the seconds from a given time (Integer).
SEEK - FunctionReturns the current read/write position within a file opened using the Open statement (Long).
SEEK - StatementRepositions where the next operation in a file will occur.
SENDKEYSSends keystrokes to an application.
SETAssigns an object reference to an object variable.
SETATTRDefines the attributes of a file or directory.
SGNReturns the sign of a number (Integer).
SHELLReturns the program's task id from running an executable programs (Double).
SINReturns the sine of an angle in radians (Double).
SLNReturns the straight-line depreciation of an asset over a single period of time (Double).
SPACEReturns the specified number of spaces (String).
SPCInserts a specified number (n) of spaces when writing or displaying text.
SPLITReturns the array containing a specified number of substrings (Variant).
SQRReturns the square root of a number (Double).
STOPSuspends execution.
STRReturns the text string of a number (String).
STRCOMPReturns the result of a string comparison (Integer).
STRCONVReturns the text string converted to a specific case or type (String).
STRINGReturns a repeating character of a given length (String).
STRPTRReturns a LongPtr on a 64 bit version and a Long on a 32 bit version.
STRREVERSEReturns the text string with the characters reversed (String).
SWITCHReturns a value based on expressions (Variant).
SYDReturns the sum-of-years' digits depreciation of an asset (Double).
TABUsed with the Print # statement or the Print method to position output.
TANReturns the tangent of an angle (Double).
TIME - FunctionReturns the current system time (Date).
TIME - StatementDefines the current system time.
TIMERReturns the number of seconds elapsed since midnight (Single).
TIMESERIALReturns the time for a specific hour, minute and second (Date).
TIMEVALUEReturns the time given a string representation of a time (Date).
TRIMReturns the text string removing leading and trailing spaces (String).
TYPENAMEReturns the data type of the variable as a string (String).
TYPEOFReturns the object data type.
UBOUNDReturns the largest subscript in a given dimension of an array (Long).
UCASEReturns the text string with all the characters converted to uppercase (String).
UNLOADRemoves an object from memory.
UNLOCKControls access to a file.
VALReturns the numbers contained in a string as a numeric value of the appropriate data type (Double).
VARPTRReturns a LongPtr on a 64 bit version and a Long on a 32 bit version.
VARTYPEReturns the number indicating the data type of a variable (Integer).
WEEKDAYReturns the number representing the day of the week for a given date (Integer).
WEEKDAYNAMEReturns the day of the week as a string (String).
WIDTHAssigns an output line width (characters) for the open file.
WRITEWrites data to a sequential file.
XORThe bitwise exclusion operator.
YEARReturns the year from a date (Integer).
NAME
Renames an existing file or directory.
NOT
The logical 'NOT' operator (Boolean).
NOW
Returns the current system date and time (Date).
NPER
Returns the number of periods for an investment (Double).
NPV
Returns the present value of a series of unequal cash flows at regular intervals (Double).
OBJPTR
Returns a LongPtr on a 64 bit version and a Long on a 32 bit version.
OCT
Returns the number converted to octal (Variant).
OPEN
Opens a text file or CSV file.
OR
The logical 'OR' operator (Boolean).
PARTITION
Returns a string indicating which particular range it falls into (String).
PMT
Returns the amount of principal and interest paid in a given period in a series of equal cash flows at regular intervals (Double).
PPMT
Returns the amount of principal paid in a given period in a series of equal cash flows at regular intervals (Double).
PRINT
Writes display-formatted data to a sequential file.
PUT
Writes data from a record into a text file.
PV
Returns the present value of an annuity (Double).
QBCOLOR
Returns the RGB colour corresponding to the specified colour number (Long).
RAISEEVENT
Fires an event declared at module level within a class, form or document.
RANDOMIZE
Initialises the random number generator.
RATE
Returns the interest rate for a series of equal cash flows at regular intervals (Double).
REDIM
Initialises and resizes a dynamic array.
REM
Specifies a single line of comments.
REPLACE
Returns the text string with a number of characters replaced (String).
RESET
Closes all files open with the Open statement.
RGB
Returns the number representing an RGB colour value (Long).
RIGHT
Returns a number of characters from the right of a string (String).
RMDIR
Removes an existing directory.
RND
Returns a random number between 0 and 1 (Single).
ROUND
Returns a number rounded to a given number of decimal places (Double).
RSET
Right aligns a string within a string variable.
RTRIM
Returns the text string without trailing spaces (String).
SAVEPICTURE
Saves a graphic image from an objects Picture or Image property to a file.
SAVESETTING
Writes to the registry and saves a section or key in the registry.
SECOND
Returns the seconds from a given time (Integer).
SEEK - Function
Returns the current read/write position within a file opened using the Open statement (Long).
SEEK - Statement
Repositions where the next operation in a file will occur.
SENDKEYS
Sends keystrokes to an application.
SET
Assigns an object reference to an object variable.
SETATTR
Defines the attributes of a file or directory.
SGN
Returns the sign of a number (Integer).
SHELL
Returns the program's task id from running an executable programs (Double).
SIN
Returns the sine of an angle in radians (Double).
SLN
Returns the straight-line depreciation of an asset over a single period of time (Double).
SPACE
Returns the specified number of spaces (String).
SPC
Inserts a specified number (n) of spaces when writing or displaying text.
SPLIT
Returns the array containing a specified number of substrings (Variant).
SQR
Returns the square root of a number (Double).
STOP
Suspends execution.
STR
Returns the text string of a number (String).
STRCOMP
Returns the result of a string comparison (Integer).
STRCONV
Returns the text string converted to a specific case or type (String).
STRING
Returns a repeating character of a given length (String).
STRPTR
Returns a LongPtr on a 64 bit version and a Long on a 32 bit version.
STRREVERSE
Returns the text string with the characters reversed (String).
SWITCH
Returns a value based on expressions (Variant).
SYD
Returns the sum-of-years' digits depreciation of an asset (Double).
TAB
Used with the Print # statement or the Print method to position output.
TAN
Returns the tangent of an angle (Double).
TIME - Function
Returns the current system time (Date).
TIME - Statement
Defines the current system time.
TIMER
Returns the number of seconds elapsed since midnight (Single).
TIMESERIAL
Returns the time for a specific hour, minute and second (Date).
TIMEVALUE
Returns the time given a string representation of a time (Date).
TRIM
Returns the text string removing leading and trailing spaces (String).
TYPENAME
Returns the data type of the variable as a string (String).
TYPEOF
Returns the object data type.
UBOUND
Returns the largest subscript in a given dimension of an array (Long).
UCASE
Returns the text string with all the characters converted to uppercase (String).
UNLOAD
Removes an object from memory.
UNLOCK
Controls access to a file.
VAL
Returns the numbers contained in a string as a numeric value of the appropriate data type (Double).
VARPTR
Returns a LongPtr on a 64 bit version and a Long on a 32 bit version.
VARTYPE
Returns the number indicating the data type of a variable (Integer).
WEEKDAY
Returns the number representing the day of the week for a given date (Integer).
WEEKDAYNAME
Returns the day of the week as a string (String).
WIDTH
Assigns an output line width (characters) for the open file.
WRITE
Writes data to a sequential file.
XOR
The bitwise exclusion operator.
YEAR
Returns the year from a date (Integer).

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top