Question

excel中建立按钮键

按钮键上的名字输入为1，我点一下，按钮名称变成2，再点一下又变回1.再点一下又变成2.

Answer 1

Private Sub CommandButton1_Click()
If CommandButton1.Caption = 1 Then
CommandButton1.Caption = 2
Else
CommandButton1.Caption = 1
End If
End Sub

Answer 2

有截图的话，最好来个截图。

Answer 3

借用 lnzzxzy 的代码
Private Sub CommandButton1_Click()
CommandButton1.Caption = IIF(CommandButton1.Caption ="1", 2, 1)
End Sub