use textbox content to copy and rename worksheet

[stewie09]

Can anyone please help me with this Excel task? I am trying to create a macro which I will allow me to enter a name in a textbox on a userform. Then when I click on the Create button, the macros makes a copy of a worksheet (the worksheet is currently named Cal2007.). After making the copy. The copied worksheet should be renamed using the name that was entered in the text box.

Thanks

 

[HalfAce]

Hello stewie09, welcome to the board.
Assuming your textbox is still named 'TextBox1' you can use something like this
for the code in your userform's Create button.

Sheets("Cal2007").Copy Before:=Sheets(1)
ActiveSheet.Name = TextBox1.Value

 

[stewie09]

HalfAce, thank you very much for providing the code. I really appreciate your help.