MsgBox, vbNo problem

Hey guys.

Im having some problem with a simpe yes/no msgbox.
I have a macro that creates a new sheet whose name depends on some value.
I have created this little thing that checks if a sheet with the same name exists and
if so then a msgbox will show where the user can choose to delete the existing sheet.

If the user selects yes, the code works just fine.
The sheet is deleted and jumps to the point SheetNotFound where the macro
continues like normal.
The problem happens when the user presses No.
What I want to happen is that the macro should just stop.
I have tried this:

Please Login or Register  to view this content.

Didnt work.


So I tried to have it jump to the last line of the macro before End Sub but it doesnt
jump there, instead it just continues down the macro until it crashes due to the fact that it tries to make a sheet with duplicate name.

Here is my code:

Please Login or Register  to view this content.

Your nesting of the IF statements is not right. Look up the IF - ElseIf syntax in the Excel VBA Help files.

try

Please Login or Register  to view this content.

Thats works! Thanks!

Weird..
I got that code from the Excel 2003 Bible..
Must be a typo or something.

If my suggestion beats an "Excel 2003 Bible" code, that's surely down to bad proof-reading rather than anything else.

Please mark the thread as solved, if you feel your problem has been addressed in a satisfactory way.

cheers, teylyn


If you are satisfied with the solution(s) provided, 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