commandBtn Caption to sheet name

Hello,

show your code and we can help you to amend it.

@ideatronz;

See this:

Private Sub CommandButton1_Click()
    For i = 1 To Sheets.Count
        If Sheets(i).Name = CommandButton1.Caption Then GoTo theExit:
    Next
    Set newSH = Worksheets.Add
    newSH.Name = CommandButton1.Caption
theExit:
End Sub