Naming a tab by a cell value

[mpalermino76]

Hello:

I don't know if excel will actually do this, but can you have a tab be named (or renamed) when a particular cell has a value inputted into it. What I envision is that a tab may say "Marbles" but when you type "Coins" into cell A12 (for example) that tab changes from Marbles to Coins. Any ideas?

I appreciate your feedback.

-Marc

 

[CWatts]

You can make a macro and assign a button to it

Sub RenameSheet()
    ActiveSheet.Name = [A12].Value
End Sub

or you can set it to change automatically when you update the cell

Private Sub Worksheet_Change(ByVal Target As Range)
    ActiveSheet.Name = [A12].Value
End Sub