Msg box response is ignored

Hello,

I am trying to achieve a response from a msgbox which will either continue with the sub or exit. I think my code is right but it doesn't seem to work and just carrys on regardless. Any help would be appreciated.

Please Login or Register  to view this content.

Welcome to the forum. One of the important forum rules is to wrap

Please Login or Register  to view this content.

aaron.ronnie

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I have added Code Tags this time, please be sure to read the Forum rules before posting again.

This code asks for a response then copies the data. Note it does not use the loop - which would take longer, nor is it necessary to activate or select sheets and ranges

Please Login or Register  to view this content.

You habe indicated that the replies have resolved your pronlem - Please mark your thread as Solved

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


Re Wrapping VBA code

The easiest way to use code tags is to click on the # icon in the text formatting window

This will add
[ Code] [\ Code]
to your message window with the cursor between the ][ brackets - this is were your VBA code goes.
You will not see your code displayed correctly until you preview or post your message

Note:- there is no space before the word Code like I have shown in the example above

Please Login or Register  to view this content.