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:
Userform module
Module
Please Login or Register to view this content.
Please Login or Register to view this content.
Thank you so much!
I didn't realize I had to separate them out like that!
Glad to help, thanks for rep and marking as solved
Sorry but, just a follow up question.... What If I have a table in sheet1 as a template and I want the new sheet above to be created and have the same table in it as sheet1?
So an example would be, I name the new sheet name in my textbox1 value and click create, the code above works perfectly to create a new tab and name it my textbox1 value... but what I want is that sheet to also have the same layout as my template sheet1... I can only get the code to copy the sheet1 and create a new worksheet, not paste into the one I just created.
I am using this code in my module after the one above.
HTML Code:
Last edited by cwelsh; 04-18-2019 at 09:36 AM.
Please Login or Register to view this content.
Thank you but for some reason it makes the table all squished
Perhaps I need to aut0fit?
Yes that got it!
Again, thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks