May 1995
Beginner
508 pages
16h 14m
English
CDbl Function
CDbl(expression)expression
Use: Required
Data Subtype: Numeric or String
-1.79769313486232E308 to -4.94065645841247E-324 for negative values; 4.94065645841247E-324 to 1.79769313486232E308 for positive values.
expression cast as a Variant with a Double
subtype.
Converts expression to a Variant with a
Double subtype.
If the value of expression is outside the
range of the double datatype, an overflow error is generated.
Expression must evaluate to a numeric value; otherwise, a type mismatch error is generated.
Dim dblMyNumber as Double
If IsNumeric(sMyNumber) then
dblMyNumber = CDbl(sMyNumber)
End IfUse IsNumeric to test whether
expression evaluates to a number.
| IsNumeric Function |
Read now
Unlock full access