vbYesNoCancel - What's Going On?

[sha76]

I've got a message box as follows:

MsgBox(

"Instructions"

, vbYesNoCancel)

It's fine if the user selects 'Yes', but if either 'No' or 'Cancel' are selected it returns a value of 3(vbAbort). Am I missing something here?

Thanks for your help

Sharon

 

[RobBroekhuis]

That's odd. Either something else in your code isn't quite right, or your Excel is messing up. If after restarting this still occurs, post a little more of your code around it. I bet we can help.
Rob

 

[sha76]

Amazing how you spot your own mistakes when you try & explain your code to someone else! Does help if you assign the value of your message box to a variable before trying to use it in an if statement!
Oh well, caffine obviously not working today. Thanks for your help,

Sharon