VBA's Functions for Simple 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 Simple Data Conversion

 
Function(Arguments)      Data Type Returned         
CBool(number)            Boolean        
CByte(expression)        Byte        
CCur(expression)         Currency        
CDate(expression)        Date        
CDbl(expression)         Double        
CInt(expression)         Integer        
CLng(expression)         Long        
CSng(expression)         Single        
CStr(expression)         String        
CVar(expression)         Variant








Related examples in the same category

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