Data validation on an input box

Hello all! I think this is an easy one but multiple attempts on my own are getting me nowhere. I just need to make the user enter a new worksheet name that ends with the characters "SD". I think I'm close but code stops on the ???? below. I tried newname, InputBox . . . And I'm not sure what the "1" means.. Is that how many places on the right? Should it be "2" for "sd"?

Please Login or Register  to view this content.

Also, I need something on the end that returns to the input box if they don't comply with the naming requirement.


Thanks in advance!! Most helpful people here!

The following code would work:

Please Login or Register  to view this content.

You might want to think about how to handle these possibilities:

1. the sheet name already exists
2. an invalid sheet name is entered, e.g. 'a//sd' passes the test but is an invalid sheet name
3. cancel is clicked