Problems with "Exit Sub"

[wishny]

Hi everyone!

I have the following VBA code:

Please Login or Register  to view this content.

I am beginner with VBA. All of the code which starts with a space I have recorded from a macro. The other lines I found on the web and copy paste it.

The problem about this code is that after the message box pops up, the sub does not end after clicking on cancel. So no matter that you click the macro just goes on.

Hope that someone can help me here.

Thanks!

[shg]

You didn't return the result of MsgBox to the variable:

Please Login or Register  to view this content.

The line at the top of the module is the most important.