For what it's worth, the data type of the return value from a
Msgbox is a "Long".

Jim Cone
San Francisco, USA


"Jim Thomlinson" wrote in message
...
To be reallllly pick about Bob's code ans should be declared as an integer.
Without specifying as Bob has done you end up with a variant which requires
extra overhead. In this application it won't really make any difference but
it is alway good programming to declare your variable explicitly. This is a
really picky point but I get people asking me why when they type the dot
after a key word "why they don't get a drop down list". Very often this is
the reason....
dim ans as integer
HTH