Signature (Visual Basic / VBA)
Public Function CanBeSingle( _
ByVal vValue As Variant _
) As Boolean
Code Example
CanBeSingle(34) = True
CanBeSingle(1234.56) = True
CanBeSingle(#12/31/95#) = True
CanBeSingle("1") = True
CanBeSingle("1E1000") = False
CanBeSingle("A word.") = False
Parameters
| Parameter | Description |
|---|---|
| vValue | The argument which is checked to see if it can be converted to a Single value. Function returns True if vValue contains a numeric value, a date, or a numeric string value which is within the range of values supported by the Single data type. Function returns False otherwise, such as if vValue is out-of-range, Null, an error, or an object pointer. |