Check to see if sheet exists

Hi again

Help with ON error, I have a userform textbox that a user can name a new sheet which is copied from a master template sheet, my problem is if the name already exists it errors out, I have had a go with on error resume next, have searched here but I admit I am struggling with such a simple task, all I want is basically if the new name(sheet) from Textbox1 value already exists then msgbox to "try different name", thanks in advance.....code below

Please Login or Register  to view this content.

Untested.

Please Login or Register  to view this content.

Thanks guys

Sixthsense your code seems to work in reverse....it brings up the msgbox on sheets name that DONT exist not on ones that do
AB33 your code does kinda work the msgbox comes up on duplicate sheet names but after clicking ok it runs the rest of my code and makes a copy of the template sheet

AB33 your code does kinda work the msgbox comes up on duplicate sheet names but after clicking ok it runs the rest of my code and makes a copy of the template sheet

I thought is not that what you want.
The code tests if sheet exists, it does not, it names the active sheet using the name of textbox. If it does exist, it skips and you get a message.

Thanks for trying guys but I can not get any of the above coding to work with mine, hopefully my users will not input a duplicate name lol

Thanks codeslizer

I had already tried that and thought that would have been too easy, didnt work, I didnt think finding a small bit of code to check sheet names would be so difficult lol I am sure they work with other peoples bits of code, I guess the way I am doing the naming of a sheet using a userform and textbox makes it a little harder to get it all to blend together


Thanks

Thank you codeslizer, I can use this

Thanks for taking the time to help me

Done codeslizer