<p>This declaration causes an overflow in VBA:</p>

<pre><code>Const OVERFLOWS As Long = 10 * 60 * 60
</code></pre>

<p>whereas setting the value directly is fine:</p>

<pre><code>Const COMPILES_OK As Long = 36000
</code></pre>

<p>How do you persuade VBA to treat literal integers as longs?</p>

<p>Thanks</p>

Add the
```
long
```
suffix
```
&
```
to at least one number:
```
```
Const OVERFLOWS As Long = 10& * 60 * 60
```
```
Note that using the
```
CLNG
```
function to convert the values to
```
long
```
will not work, because VBA does not allow assigning the return value of a function to a constant.