Need to adjust the length of data for accepted by input vba

**kjsconv** · 03-31-2013, 12:41 PM

I am entering records that have long account numbers.

Please Login or Register  to view this content.

When I enter the number that has 16 digits, I get an error message "overflow".

I don't see where I can adjust the length of the allowed number.

**AndyLitch** · 03-31-2013, 12:47 PM

An account number (despite being numerical in appearance) is only used as an identification, maths is never performed on the acc no. so you can dimension your variable as a string which will take as many digits as you like.
If you really want the numeric then dimension your variable as a double...
Also - double check your applicationInputbox type ... I can't remember the numbers offhand but a type 2 may indicate an integer or a long which will restrict the number of digits it can handle.