Overflow Error

**narrowgate88** · 07-09-2010, 05:23 PM

I'm getting an overflow error. I'm not sure I've defined x and y correctly. Basically, x and y are both input boxes where the user is going to enter a number. Then later on, those 2 numbers are added together in a formula. I had been getting #NAME?, and so I've been trying to adjust it and this is the latest version.

Code was too long, so I'm attaching the file. It's in the frmRSCV code.

**Deamo** · 07-09-2010, 06:08 PM

depending on the size of the number entered.. the Integer datatype may not be able to handle it.

Integers can only handle a size of -32,767 to 62,767 - if your number is bigger than that, you'll get an overflow error.

try declaring them as Long or Double datatypes

**protonLeah** · 07-09-2010, 06:25 PM

Your code does nothing with x or y after being initialized to the values from the input boxes.
From Help:

Integer (whole numbers) )variables are stored as 16-bit (2-byte) numbers ranging in value from -32,768 to 32,767

Thats a small range. You seem to be working with money and so should be using SINGLE (decimals)

ranging in value from -3.402823E38 to -1.401298E-45 for negative values and from 1.401298E-45 to 3.402823E38 for positive values

**DonkeyOte** · 07-10-2010, 02:08 AM

If the entry is (as implied by Type) to always be numeric you may wish to investigate the use of Application.InputBox rather than InputBox which will give you added control regards data input (see Type)