A | B | C | D | E | F | G | H | I | J | K | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z |
VBA Function | Description | Category |
---|---|---|
A | ||
ABS | Returns the absolute value of a number | Math Functions |
ARRAY | Returns a variant that contains an array | Array Function |
ASC | Converts the first character of string to its ASCII value | Text Functions |
ATN | Returns the arctangent of a number | Math Functions |
C | ||
CALLBYNAME | Executes a method of an object, or sets or returns a property of an object. | System Functions |
CBOOL | Converts a value to a boolean | Convert Functions |
CBYTE | Converts an expression to byte data type | Convert Functions |
CCUR | Converts a value to currency | Convert Functions |
CDATE | Converts a value to a date | Convert Functions |
CDBL | Converts a value to a double | Convert Functions |
CDEC | Converts an expression to decimal data type | Convert Functions |
CHDIR | Used to change the current directory or folder | File Functions |
CHDRIVE | Used to change the current drive | File Functions |
CHOOSE | Selects and returns a value from a list of arguments | Array Function |
CHR | Returns the character based on the ASCII value | Text Functions |
CINT | Converts an expression to integer data type | Convert Functions |
CLNG | Converts a value to a long integer | Convert Functions |
COS | Returns the cosine of a number | Math Functions |
CREATEOBJECT | Creates and returns a reference to an ActiveX object. | System Functions |
CSNG | Converts a value to a single-precision number | Convert Functions |
CSTR | Converts a value to a string | Convert Functions |
CURDIR | Returns the current path | File Functions |
CVAR | Converts a value to a variant | convert Functions |
CVDATE | Converts an expression to date data type | Convert Functions |
CVERR | Produces an Error data type for a supplied error code. | System Functions |
D | ||
DATE | In Excel worksheet function - convert a supplied year, month, and day into excel date. In VBA - Return current system date | Date/Time Function |
DATEADD | Returns a date with a specific date interval added to it | Date/Time Function |
DATEDIFF | Calculates the number of days, months, or years between two dates. | Date/Time Function |
DATEPART | Returns a specified part of a given date | Date/Time Function |
DATESERIAL | Returns a date for a specified year, month, and day | Date/Time Function |
DATEVALUE | Converts a string to date | Date/Time Function |
DAY | Returns the day of the month of a date | Date/Time Function |
DDB | Returns the depreciation of an asset based on the double-declining balance method | Financial Functions |
DIR | Returns the first filename that matches the pathname and attributes specified | File Functions |
DOEVENTS | Yields execution so that the operating system can process other events. | System Functions |
E | ||
ENVIRON | Returns the value of an operating system environment variable | Info Functions |
EOF | Returns an Integer containing the Boolean value True when the end of a file opened for Random or sequential Input has been reached. | System Functions |
ERROR | Returns the error message corresponding to a supplied error code. | System Functions |
EXP | Returns e raised to the nth power | Math Functions |
F | ||
FILEATTR | Returns the mode of a file that has been opened using the Open statement. | File Functions |
FILECOPY | FileCopy Copies a file | File Functions |
FILEDATETIME | Returns the date and time of when a file was created or last modified | File Functions |
FILELEN | Returns the size of a file in bytes | File Functions |
FILTER | Returns a subset of a supplied string array, based on supplied criteria. | Array Function |
FIX | Truncates a number to an integer (rounding negative numbers towards zero). | Math Functions |
FORMAT | Applies a format to an expression and returns the result as a string. | Text Functions |
FORMAT DATES | Takes a date expression and returns it as a formatted string | Convert Functions |
FORMAT NUMBERS | Takes a numeric expression and returns it as a formatted string | Convert Functions |
FORMATCURRENCY | Returns a number as a string, formatted as currency | Convert Functions |
FORMATDATETIME | Returns a number as a string, formatted as a date and/or | Convert Functions |
FORMATNUMBER | Returns a number as a formatted string | Convert Functions |
FORMATPERCENT | Returns a number as a string, formatted as a percentage | Convert Functions |
FREEFILE | Returns an Integer representing the next file number available for use by the Open statement. | System Functions |
FV | Returns the future value of an investment | Financial Functions |
G | ||
GETALLSETTINGS | Returns a list of key settings and their respective values (originally created with SaveSetting) from an application's entry in the Windows registry or (on the Macintosh) information in the application’s initialization file. | System Functions |
GETATTR | Returns an integer that represents the attributes of a file, folder, or directory | File Functions |
GETOBJECT | Returns a reference to an object provided by an ActiveX component. | System Functions |
GETSETTING | Returns a key setting value from an application's entry in the Windows registry or (on the Macintosh) information in the application’s initialization file. | System Functions |
H | ||
HEX | Converts from decimal to hexadecimal | Convert Functions |
HOUR | Returns the hour of a time | Date/Time Function |
I | ||
IIF | Returns one of two parts, depending on the evaluation of an expression. | System Functions |
IMESTATUS | Returns an Integer specifying the current Input Method Editor (IME) mode of Microsoft Windows; available in East Asian versions only. | System Functions |
INPUT | Returns String containing characters from a file opened in Input or Binary mode. | System Functions |
INPUTBOX | Displays a dialog box prompting the user for input. | I/O Function |
INSTR | Return the starting position of one text string within another text. FIND is case sensitive | Text Functions |
INSTRREV | Returns the position of a substring within a string, searching from right to left. | Text Functions |
INT | Returns the integer portion of a number | Math Functions |
IPMT | Returns the interest payment for an investment | Financial Functions |
IRR | Returns the internal rate of return for a series of cash flows | Financial Functions |
ISARRAY | Tests if a supplied variable is an array. | Logical Functions |
ISDATE | Tests if a supplied expression is a date. | Logical Functions |
ISEMPTY | Returns True if a variable has not been initialized | Logical Functions |
ISERROR | Return True if there is an error and false if it is no error | Logical Functions |
ISMISSING | Tests if an optional argument to a procedure is missing. | Logical Functions |
ISNULL | Tests if a supplied expression is Null. | Logical Functions |
ISNUMERIC | Tests if a supplied value is a number, and if so, TRUE; Otherwise, FALSE | Logical Functions |
ISOBJECT | Tests if a supplied variable represents an object variable. | Logical Functions |
J | ||
JOIN | Returns a string created by joining a number of substrings | Array Function |
L | ||
LBOUND | Returns the lower bound of an array | Array Function |
LCASE | Converts a supplied string to lower case text. | Text Functions |
LEFT | Returns a substring from the start of a supplied string. | Text Functions |
LEN | Returns the length of a supplied string. | Text Functions |
LOC | Returns a Long specifying the current read/write position within an open file. | System Functions |
LOF | Returns the number of bytes in an open text file | Math Functions |
LOG | Returns the natural logarithm of a number | Math Functions |
LSET | Lset Left-aligns a string within a string variable | Text Functions |
LTRIM | Removes leading spaces from a supplied string. | Text Functions |
M | ||
MACID | Used on the Macintosh to convert a 4-character constant to a value that may be used by Dir, Kill, Shell, and AppActivate. | System Functions |
MACSCRIPT | Executes an AppleScript script and returns a value returned by the script, if any. | System Functions |
MID | Returns a substring from the middle of a supplied string. | Text Functions |
MINUTE | Returns the minute of a time | Date/Time Function |
MIRR | Returns the modified internal rate of return for a series of cash flows | Financial Functions |
MKDIR | Used to create a new folder or directory | File Functions |
MONTH | Returns the month of a date | Date/Time Function |
MONTHNAME | Returns a string representing the month given a number from 1 to 12 | Date/Time Function |
MSGBOX | Displays a modal message box | I/O Function |
N | ||
NORM.DIST | the normal cumulative distribution (New in Excel 2010 - replaces the Normdist function) | Math Functions |
NORM.INV | the inverse of the normal cumulative distribution (New in Excel 2010 - replaces the Norminv function) | Math Functions |
NORM.S.DIST | the inverse of the standard normal cumulative distribution (New in Excel 2010 - replaces the Normsinv function) | Math Functions |
NORM.S.INV | the normal cumulative distribution (Replaced by Norm.Dist function in Excel 2010) | Math Functions |
NORMDIST | the inverse of the normal cumulative distribution (Replaced by Norm.Inv function in Excel 2010) | Math Functions |
NORMINV | the standard normal cumulative distribution (Replaced by Norm.S.Dist function in Excel 2010) | Math Functions |
NORMSDIST | the inverse of the standard normal cumulative distribution (Replaced by Norm.S.Inv function in Excel 2010) | Math Functions |
NORMSINV | the inverse of the standard normal cumulative distribution (Replaced by Norm.S.Inv function in Excel 2010) | Math Functions |
NOT | operator | Logical Functions |
NOW | Returns the current system date in the format of Month, Day, Year and time | Date/Time Function |
NPER | Returns the number of periods for an investment | Financial Functions |
NPV | Returns the net present value of an investment | Financial Functions |
O | ||
OCT | Converts from decimal to octal | Convert Functions |
OR | Returns TRUE if any of the conditions are TRUE | Logical Functions |
P | ||
PARTITION | Returns a Variant (String) indicating where a number occurs within a calculated series of ranges. | System Functions |
PMT | Returns the payment amount for a loan | Financial Functions |
PPMT | Returns the payment on the principal for a particular payment | Financial Functions |
PV | Returns the present value of an investment | Financial Functions |
Q | ||
QBCOLOR | Returns a Long representing the RGB color code corresponding to the specified color number. | System Functions |
R | ||
RANDOMIZE | Used to change the seed value used by the random number generator for the RND function | Math Functions |
RATE | Returns the interest rate for an annuity | Financial Functions |
REPLACE | Replaces a substring within a supplied text string. | Text Functions |
RGB | Returns a Long whole number representing an RGB color value. | System Functions |
RIGHT | Returns a substring from the end of a supplied string. | Text Functions |
RMDIR | RmDir Removes an empty directory | File Functions |
RND | Returns a random number between 0 and 1 | Math Functions |
ROUND | Rounds a number to a specific number of decimal places | Math Functions |
RSET | RSet Right-aligns a string within a string variable | Math Functions |
RTRIM | Removes trailing spaces from a supplied string. | Text Functions |
S | ||
SECOND | Returns the second of a time | Date/Time Function |
SEEK | Returns the current position in a text file | Text Functions |
SETATTR | Used to set the attributes of a file | File Functions |
SGN | Returns the sign of a number | Math Functions |
SHELL | Runs an executable program and returns a Variant (Double) representing the program's task ID if successful, otherwise it returns zero. | System Functions |
SIN | Returns the sine of an angle | Math Functions |
SLN | Returns the depreciation of an asset based on the straight-line depreciation method | Financial Functions |
SPACE | Creates a string consisting of a specified number of spaces. | Text Functions |
SPC | Used with the Print # statement or the Print method to position output. | System Functions |
SPLIT | Used to split a string into substrings based on a delimiter | Text Functions |
SQR | Returns the square root of a number | Math Functions |
STR | Returns a string representation of a number | Text Functions |
STRCOMP | Compares two strings and returns an integer representing the result of the comparison. If string1 is equal to string2, the StrComp function will return 0. If string1 is less than string2, the StrComp function will return -1. If string1 is greater than string2, the StrComp function will return 1. If either string1 or string2 is NULL, the StrComp function will return NULL. | Text Functions |
STRCONV | Converts a string into a specified format. | Text Functions |
STRING | Returns a repeating character or string | Text Functions |
STRREVERSE | Returns the characters of a string in reverse order | Text Functions |
SWITCH | Evaluates a list of expressions and returns the corresponding value for the first expression in the list that is TRUE | Logical Functions |
SYD | Returns the depreciation of an asset based on the sum-of-years' digits depreciation method | Financial Functions |
T | ||
TAB | Used with the Print # statement or the Print method to position output. | System Functions |
TAN | Returns the tangent of an angle | Math Functions |
TIME | Returns the current system time | Date/Time Function |
TIMER | Returns the number of seconds since midnight | Date/Time Function |
TIMESERIAL | Returns the time for a specified hour, minute, and second | Date/Time Function |
TIMEVALUE | Converts a string to a time serial number | Date/Time Function |
TRIM | Removes duplicate spaces, and spaces at the start and end of a text string | Text Functions |
TYPENAME | Returns a string that describes the data type of a | Text Functions |
U | ||
UBOUND | Returns the upper bound of an array | Array Function |
UCASE | Converts all characters in a supplied text string to upper case | Text Functions |
V | ||
VAL | Converts a text string into a numeric value | Convert Functions |
W | ||
WEEKDAY | Returns a number representing a day of the week | Date/Time Function |
WEEKDAYNAME | Returns a string representing the day of the week given a number from 1 to 7 | Date/Time Function |
WHILE-WEND | Used to create a WHILE LOOP | Logical Functions |
Y | ||
YEAR | Returns a four-digit year (a number from 1900 to 9999) given a date value | Date/Time Function |