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).
|