VBA's Functions for Complex Data Conversion : Data Type Convert « Data Type Functions « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Data Type Functions
  3. Data Type Convert

VBA's Functions for Complex Data Conversion

 
Function(Arguments)             Returns         
Asc(string)                     The ANSI character code for the first character in the string.        
Chr(number)                     The string for the specified character code (a number between 0 and 255).        
Format(expression, format)      A variant containing expression formatted as specified by format. (You'll see how Format works in "Using the Format Function to Format an Expression," later in the chapter.)        
Hex(number)                     the hexadecimal value of number.        
Oct(number)                     the octal value of number.        
RGB(number1, number2, number3)  the color value specified by number1, number2, and number3.        
QBColor(number)                 A Long containing the RGB value for the specified color.        
Str(number)                     A string representation of number.        
Val(string)                     The numeric portion of string








Related examples in the same category

1.VBA's Functions for Simple Data Conversion
2.Use CInt to convert input value to integer
3.Using the Asc Function to Return a Character Code
4.Using the Str Function to Convert a Value to a String