Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change variable type | Excel Programming | |||
Variable type | Excel Programming | |||
Type of variable | Excel Programming | |||
Variable type Confusion | Excel Programming | |||
type variable as argument of a sub | Excel Programming |