VBA cannot dim a UInteger

Question

I try to dim an unsigned integer using the line:

dim curStart as UInteger

and on running, I receive the error:

Compile Error "User-defined type not defined"

Is there a reference library that is required in VBA to allow unsigned integers?

I'm using Visual Basic for Applications 7.1.1068

Answer 1

You’re out of luck - VBA does not support unsigned types.

Use a Long instead, which is a superset of a 16 bit unsigned type.