CHANGE WORKSHEET TAB NAME WITH INPUTBOX

[Eddie G.]

Can you change a worksheet name with an inputbox function?

 

[Drmwvr7266]

I have used a Userform just for this purpose. I have a commandbutton that runs a macro similar to this:


Sub Rename()
Sheets("Sheet1").Select
Sheets("Sheet1").Name= Userform1.textbox1.value
End Sub

 

[Jay Petrulis]

Hi,

<pre>Sub test()

ActiveSheet.Name = _
Application.InputBox(Prompt:="Enter a worksheet name", Type:=2)

End Sub</pre>

Note that this has no error checking.