Too bad... Anyway yeah, all that info was helpful.
Not so too bad after all...
Private Sub Form_Load()
'aha we are working with intager
Dim a As Integer, b As Integer, c As Integer
'lets set the overflow frandly numbers for a spin
a = -21948
b = -30578
'ok now with the works
c = (a ^ 2 + b ^ 2) ^ 0.5 'can overflows for several reasons a.) trys to do a a ^ 2 in a integer memory range...
'ok now the same thing fixed:
c = CInt((CLng(a) ^ 2 + CLng(a) ^ 2) ^ 0.5)
Debug.Print c '31039
'Qustions? , comments? Send it over to microsoft.
End Sub