So i have program that ask the user for an input. It then searches the entire active workbook for a sheet with the name from the userinput. If there is a sheet with that name, it makes that the active sheet. But if there is not a sheet with that same name it creates a new sheet named after the users input. So I have a sheet called "Capitals" and if a user enters "captials" into the userbox it tries to create a new sheet called "capitals" but then i get an error that says, you cant name a sheet the same name.
here is my code
Bookmarks