Breaking a Sub with vbOKCancel...

[firefiend]

Here's my MsgBox code:

    MsgBox "Use of this macro assumes you have copied the source data to this worksheet." & _
            vbCrLf & "Please cancel this proceedure and do so now if you have not already done so.", _
            vbOKCancel + vbQuestion, "Before You Proceed!"

If the user clicks cancel I want to stop the execution of the remaining code. Currently, when cancel is clicked the code executes anyway which ends up producing a bunch of jibberish because it is out of context.

Is there a way, using the vbOKCancel return value to actually break the Sub?

~Len

[VBA Noob]

Does this link help

http://www.ozgrid.com/VBA/inputbox.htm

VBA Noob

[royUK]

Surely it's better to just test for the data's existence, or automate the copying.

[firefiend]

Surely it's better to just test for the data's existence, or automate the copying.

The copying can't be automated because the source format isn't consistent and the data is too precarious to write testing code. I really Just needed a simple reminder for the user.

VBAnoob's link was just the thing.

[firefiend]

That's awesome, Thanks.


~Len