Integer data type

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

The type-declaration character for Integer is the percent (%) sign.

You can also use Integer variables to represent enumerated values. An enumerated value can contain a finite set of unique whole numbers, each of which has special meaning in the context in which it is used. Enumerated values provide a convenient way to select among a known number of choices, for example, black = 0, white = 1, and so on.

It's a good programming practice to define constants by using the Const statement for each enumerated value.

See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.