View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michelle Michelle is offline
external usenet poster
 
Posts: 204
Default What Variable-type should I use

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