VBA Prompt rename sheet needs error protection against existing same sheet name

I have VBA that has a inputbox that asks to rename a sheet.
This works great. It asks for name of sheet to change, and then asks for new name of sheet.
The problem is it doesn't warm against same sheet name that may already exist.
Here is the code I have now

Also, if you hit cancel when trying to input NEW name it gives an runtime error 104 "That name already Taken"
Is it possible to Loop back to ask for NEW name again or STOP the VBA or a different error, instead of the 10 error?

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Try:

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

You're missing nothing. You are very welcome and thanks for the rep.