Easy msgbox question

[Madmax2]

What are the numbers that come back from messagebox options in vba. I know 6 equals yes but what is no and cancel. Plus any others for future reference... I used to know them but its been too long

[ItsMe]

Here you go
http://msdn.microsoft.com/en-us/libr...ffice.14).aspx

[Madmax2]

Perfect thanks

[ItsMe]

Sure thing and welcome to the forum. Another thing you can do to test a constant is to test it in the Immediate Window. So you could type the following in the Immediate Window and hit Enter.
?vbYes