Question

在excel中添加一个command按钮，点一下可以调到另一个sheet，代码要怎么编辑呢？高手帮帮忙~谢谢

Answer 1

Private Sub CommandButton1_Click()

Sheet2.Activate

End Sub

Answer 2

点一下，跳到选则的Sheet
Sub 按钮1_Click()
Dim name As String
Dim ws As Worksheet
name = InputBox("请输入要转到的Sheet名称：")
Set ws = ThisWorkbook.Worksheets(name)
ws.Activate
End Sub