Curious Overflow Error 2

[IanAble]

Hi all. I'm getting a really strange Overflow error when multiplying numbers. Here's what I've found:

Msgbox 60 * 1 - no error
Msgbox 60 * 10 - no error
Msgbox 60 * 100 - no error
Msgbox 60 * 1000 - overflow error.

What am I missing?

 

[RoyVidar]

Msgbox clng(60) * 1000 ' - no overflow error.

VBA I think, will try to use the smallest datatype possible, based on the numbers provided. Here that would be integer, where the result of the operation would overflow. Explicitly casting at least one of them to a larger datatype, should normally work.

Roy-Vidar

 

[IanAble]

Thanks Roy it worked like a charm. I'll have to watch out for that in the future!

 

[PHV]

Another way:
Msgbox 60 * 1000#

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886