Stop Macro after cancel is on vbCancel is clicked

**juliorevka** · 03-08-2012, 03:42 PM

How do you use vbOKCancel to exit out of a macro? Here is my attempt, but even though I press cancel, my macro continues running.

Please Login or Register  to view this content.

**Bob Phillips** · 03-08-2012, 03:51 PM

Try this

Please Login or Register  to view this content.

**juliorevka** · 03-08-2012, 04:08 PM

Thanks, it worked if false is used without quotation marks.

**juliorevka** · 03-08-2012, 04:23 PM

Wait,

When I tried to use the macro, it exited before completing its task even though I didn't click cancel. The problem is only in the last prompt (i.e. if I get rid of the vbCancel mechanism here, it works even though they are in the other ones). What can I do?

Please Login or Register  to view this content.

If I delete this, it works, however, I want the option of cancelling out of this box.

Please Login or Register  to view this content.

**Bob Phillips** · 03-08-2012, 06:54 PM

This seems to work OK.

Please Login or Register  to view this content.

**Bob Phillips** · 03-08-2012, 06:57 PM

BTW, InputBox does not have a Buttons argument, it only has OK and Cancel buttons. So, where you are putting vbOKCancel, that is not setting the buttons, it is setting a default value of 1 (vbOKCancel is a constant value 1).