Issue converting string to number..

[cummins]

I found a problem with my code where I was using CInt to convert string values into numeric. However, I have tried using CDbl and CLng and I still don't get the value. "27623" converts without issue, "72702" will not. Is there any way that makes sense?

[Mordred]

I just ran the following without problem

Please Login or Register  to view this content.

[shg]

The Integer data type is limited to the range -32768 to 32767.

Mordred's conversion is (implicitly) CLng()

[Colin Legg]

With "72702", if you use CInt() or declare the variable as an Integer, then you will get an overflow error. This is because Integers in VBA are 16-bit and hold whole numbers between -32,768 and 32,767 (inclusive). Declaring the variable as a Long and using CLng() should be fine.

Please Login or Register  to view this content.

[Mordred]

Is using the CLng() function a preferred way to parse a string over what I proposed?

[Colin Legg]

Yes, in VBA it is considered good practice to explicitly convert your data types rather than implicitly convert (coerce) your data types.

As an aside: I know you were getting a bit into VB .Net on another thread. In VB .Net there's the statement "Option Strict On" which disallows narrowing.