Hi,

this is because an integer has a maximum value of 32000 so when the code
tries to execute vba.cint(text.value) there is an overflow of the memory
allocated for that variable.

to use larger numbers, depending on the desired precision, you would use a
Single, a Double, or a Long

so instead ogf using cInt(...) you need to use one of these:

vba.clng(...)
vba.CDbl(...)
vba.CSng(..)

HTH

Philip

"Lucifix" wrote:


Now I recived error when I tried to enter 6 digit number. I recived this
message:

Run-time error '6':

Overflow
:(


--
Lucifix
------------------------------------------------------------------------
Lucifix's Profile: http://www.excelforum.com/member.php...o&userid=29179
View this thread: http://www.excelforum.com/showthread...hreadid=495452