View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff[_2_] Harald Staff[_2_] is offline
external usenet poster
 
Posts: 449
Default 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