CInt (function)

Syntax CInt(expression)
Description Converts expression to an Integer .
Comments This function accepts any expression convertible to an Integer , including strings. A runtime error is generated if expression is Null . Empty is treated as 0 . The passed numeric expression must be within the valid range for integers:
???????32768 <= expression <= 32767
A runtime error results if the passed expression is not within the above range. When passed a numeric expression, this function has the same effect as assigning a numeric expression to an Integer . Note that integer variables are rounded before conversion. When used with variants, this function guarantees that the expression is converted to an Integer variant ( VarType 2).
Example This example demonstrates the various results of integer manipulation with CInt.
Sub Main()
????'(1) Assigns i# to 100.55 and displays its integer representation (101).
????I# = 100.55
????MsgBox "The value of CInt(i) = " & CInt(i#)
????'(2) Sets j# to 100.22 and displays the CInt representation (100).
????j# = 100.22
????MsgBox "The value of CInt(j) = " & CInt(j#)
????'(3) Assigns k% (integer) to the CInt sum of j# and k% and displays k% '(201).
????k% = CInt(i# + j#)
??????MsgBox "The integer sum of 100.55 and 100.22 is: " & k%
????'(4) Reassigns i# to 50.35 and recalculates k%, then displays the result
????'(note rounding).
????i# = 50.35
????k% = CInt(i# + j#)
????MsgBox "The integer sum of 50.35 and 100.22 is: " & k%
End Sub
See Also CCur (function); CBool (function); CDate, CVDate (functions); CDbl (function); CLng (function); CSng (function); CStr (function); CVar (function); CVErr (function); Integer (data type).