VBA Long data type overflow

[Jean Stax]

Hi !

The following code generates Overflow error:

Dim NumberP As Long
NumberP = 1078282205 * 31

According to MSDN:
Long variables are stored as signed 64-bit (8-byte) integers ranging
in value from -9,223,372,036,854,775,808 through
9,223,372,036,854,775,807.

What is going wrong there ?
Maybe VBA Long data size differs from VB Long data size ?

Thanks

 

[keepitcool]

VBA long is 4byte(32bit) signed.

If you need larger numbers try Currency which is 8byte scaled integer
see VBA help DataType summary.



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[J.E. McGimpsey]

Different applications/compilers/environments do define data types
differently. For Excel (from XL/VBA Help):

 

[Chip Pearson]

Jean,

Longs are 4-bytes (32-bits) ranging in value from -2,147,483,648 to
2,147,483,647 . Where did you find that definition in MSDN?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Tom Ogilvy]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/
vadatlong.asp

Which includes a caution about VB6 Longs.