Matching the name on a sheet tab with the entry in a cell.

[dkehler]

When I enter a name into the cell C4, I would like that name to show on the sheet tab. I would like that to happen automatically whenever C4 is changed. Thank you.

 

[iggydarsa]

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$C$4" Then
        ActiveSheet.Name = Range("C4").Value
    End If
End Sub

 

[dkehler]

Thank you. I will try this tomorrow when I have time to do so. I appreciate your help.

 

[dkehler]

I need to do some more testing, but this seems to work perfectly. Thanks again.