Signature (Visual Basic / VBA)
Public Function FractionalToReal( _
ByRef rReal As Variant _
, Optional ByVal vSupportStringDates As Variant _
) As Boolean
Code Examples
Assuming
Dim varNum As Variant
varNum = "3/4"
for example
FractionalToReal(varNum) = True
leaves
varNum = .75
Assuming
Dim varNum As Variant
varNum = 34.5
for example
FractionalToReal(varNum) = True
leaves
varNum = 34.5
FractionalToReal("4/5") = True
FractionalToReal((varNum)) = True ' #2
Parameters
| Parameter | Description |
|---|---|
| rReal | Argument which, if it represents a fraction with a string of the form "A/B", will be replaced by its numeric approximation. Function returns True if rReal could be interpreted as a number or as a string representing a fractional number. Function returns False otherwise. |
| vSupportStringDates | Determines whether the function should consider date strings to represent numbers. Set to True if the function should consider date strings like "4/5/96" to be numbers, or set to False to save time if the function should not have to deal with date strings. This function can also be used to determine if its argument CAN BE converted into a number, as in the following examples. since Visual Basic cannot modify ByRef (By Reference) arguments that are really passed ByVal (By Value). In example #2, varNum will not be replaced with its numeric equivalent (.8) because by putting the variable in parentheses will force VB to pass it by value. |
Notes & Version History
| Note | This function is substantially similar to the ComplexStringToReals function except that ComplexStringToReals works on complex numbers instead of fractions. |
| Summary | If Value is a fractional number of the form "A/B" then rReal = A / B If Value is a numeric value then rReal remains unchanged. If Value is "A/0" or non-numeric function returns false. |