Hello,

I am struggling on how to get my code to work. I want it to use a field from a user form to create a new worksheet and rename it whatever is in the field. What I am getting stuck on is how to make the code check if that name is already taken...If it isn't then go ahead and create it, if not, give msgbox.

HTML Code: