- #Comprehensive list of microsoft excel functions full#
- #Comprehensive list of microsoft excel functions code#
Returns an integer representing the code for a supplied character.Ĭonverts an expression to a Boolean data type.Ĭonverts an expression to a Byte data type.Ĭonverts an expression to a Currency data type.Ĭonverts an expression to a Date data type.Ĭonverts an expression to a Double data type.Ĭonverts an expression to a Decimal data type. Selects a value from a list of arguments.Įvaluates an expression and returns one of two values, depending on whether the expression evaluates to True or False.Įvaluates a list of Boolean expressions and returns a value associated with the first true expression. Returns the error message corresponding to a supplied error code. Produces an Error data type for a supplied error code. Tests if a supplied variable represents an object variable. Tests if a supplied expression is numeric.
Tests if an optional argument to a procedure is missing. Tests if a supplied expression represents an error. Tests if a supplied expression is a date. Tests if a supplied variable is an array. Removes leading and trailing spaces from a supplied string.Ĭonverts a supplied string to upper case text. Removes trailing spaces from a supplied string.Ĭreates a string consisting of a specified number of spaces.Ĭompares two strings and returns an integer representing the result of the comparison.Ĭonverts a string into a specified format.Ĭreates a string consisting of a number of repeated characters. Returns a substring from the end of a supplied string. Replaces a substring within a supplied text string. Returns a substring from the middle of a supplied string. Removes leading spaces from a supplied string. Returns a substring from the start of a supplied string.Ĭonverts a supplied string to lower case text. Returns the position of a substring within a string, searching from right to left. Returns the position of a substring within a string.
#Comprehensive list of microsoft excel functions full#
Select a function name to go to a full description of the function with examples of use.ĭisplays a dialog box prompting the user for input.Īpplies a format to an expression and returns the result as a string. The most popular built-in VBA functions are listed below. VBA provides a large number of built-in functions that can be used in your code.