新建一个类模块Module1,在类模块中定义一个CommandButton类型的变量btn
Public btn As CommandButton
每次点击按钮是把该按钮赋给btn就可以了
Private Sub Command1_Click()
Set btn = Command1
Form1.Show
End Sub
Private Sub Command2_Click()
Set btn = Command2
Form1.Show
End Sub
Private Sub Command3_Click()
Set btn = Command3
Form1.Show
End Sub
Private Sub Command4_Click()
Set btn = Command4
Form1.Show
End Sub
在Form1中添加如下语句,可以判断按下哪个按钮
Private Sub Form_Load()
MsgBox "点击了" & btn.Caption & "按钮"
End Sub