Ending macro early

**TedH** · 01-20-2009, 12:45 AM

I need to step out of a macro based on a user respone, and I don't know how to end this macro if the user needs to correct a cell entry.

If they respond "no", I want to sub to end and select the cell where the correction needs to be made.

Thanks
Ted

Please Login or Register  to view this content.

**jasoncw** · 01-20-2009, 12:46 AM

Hi Ted. I do not see your problem. By using Exit Sub, you are exiting the macro.

**TedH** · 01-20-2009, 12:56 AM

I have a bunch of code after this. If I run it as is, it continues to run the following code....

I'll paste the code that follows in the original post.
Ted

**jasoncw** · 01-20-2009, 01:07 AM

Hi Ted.

Do you receive the message box "Check the customer name. Correct if needed."? If you do, based on what you have above, the procedure should end after you click OK.

**shg** · 01-20-2009, 01:49 AM

If you need to know if a sub completes successfully, then change it to a function that returns a Boolean, and test it in the calling sub.

**TedH** · 01-20-2009, 10:07 AM

jasoncw: I get the "check customer" msgbox; clicking yes there are no problems. On clicking "no", the end sub isn't doing it's thing; the macro continues to run because I'm getting a runtime error on the saveas function a little further down.

shg: I'm still a noob; I usually throw a dummy expression into the worksheet to see if the code works. {i.e. "serenity now!"}