Skip to main content

Excel 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.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>