What Variable-type should I use
Most of "those things" are Long. A byte would sometimes be too small.
Integers are internally translated to Long, so don't use them.
Best wishes Harald
"Michelle" wrote in message
...
A simple question - I think. I often use a variable to contain the response
from a MessageBox, I always declare it as a variant - is that necessary?
In help, the responses are always integers between 0 and 64, can I use an
Integer (or even a Byte) variable type, or are there some surprise
responses in certain circumstances. I want to be sure that this will not
generate an error.
This is how I'd normally do it...
Dim Again As Variant
' Check that the user wants to start again
Again = MsgBox(" Do you want to start again?", vbQuestion +
vbYesNo)
Is there a better way
M
|