double

[vaat]

How can I catch an overflow error when it comes and do somethinf else. So

if 5,5 * large number = overflow then
do this
else
do calculation
end if

 

[vb5prgrmr]

On Error GoTo Defined_Label is one way or
[tt]
On Error Resume Next

Result = OverFlow_Calculation

If Err.Number <> 0 Then
'Do This
Else
'Do That
End If
[/tt]

BTW, if you are having overflow errors with a double then you could change your &quot;Result&quot; Variable to a variant and
[tt]
Result = CDec(Normally_With_A_Double_OverFlow_Calculation)
[/tt]

Good Luck