• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1607
  • Last Modified:

Make a sheet tab name equal to a cell

Is there a way to make the name of a worksheet tab equal to a cell value.   Essentially I want someone to type their name in cell "A1" and then have that name become the tab name.  Is this possible?
0
Michael Keith
Asked:
Michael Keith
  • 3
  • 3
1 Solution
 
StephenJRCommented:
Something like this?
With ActiveSheet
    .Name = .Range("A1").Value
End With

Open in new window

0
 
Michael KeithAuthor Commented:
How would this activate when they type in the cell?
0
 
StephenJRCommented:
Er, well you'd have to run the macro. Is this a single sheet, any sheet...?
0
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

 
Michael KeithAuthor Commented:
Single sheet
0
 
StephenJRCommented:
In the sheet module:

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$A$1" Then
    ActiveSheet.Name = Target.Value
End If

End Sub
0
 
Michael KeithAuthor Commented:
That works.  Thanks!  
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now