Troubleshoot Overflow

[JingleRock]

I have read that the Overflow Error is frequently associated with
variable declaration. Do you have any suggestions, other than trial
and error in changing declarations, for troubleshooting this error?
Thanks for your help.

 

[Gary''s Student]

Formulate expresions to demand Double or Long math:

Sub bad_math()
MsgBox (24 * 60 * 60)
End Sub

will fail on overflow, but:

Sub good_math()
MsgBox (24# * 60 * 60)
End Sub

will work just fine.

 

[FSt1]

hi
nope. this is one case where experience really does help but even so,
everyone hits an "oops" now and then
best way is to think out your declarations before hand.
in vb help look up data type summary for most of the fine points.

Regards
FSt1

 

[Dave Peterson]

Don't use "As Integer"; use "As Long".

Don't use "As Single"; use "as double".