add sheet naming copy paste

**herukuncahyono** · 04-19-2010, 12:08 AM

hi,
I have userform (part of userform) to add new sheet and copy form & format to new sheet in same worksheet.
my code problems is:
1. why add new worksheet
2. in the same sheet add new work sheet to
my questions is:
I want add new sheet in the same worksheet by name in accordance with the textbox1,copy data & format from (blank form)sheet "form" to new sheet added.

thanks in advance
herukuncahyono

**Marcol** · 04-19-2010, 01:57 AM

Try this

Please Login or Register  to view this content.

Hope this helps

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.