做过一个双击名字就加一票,就不必那么多按钮了,特别是人数不定时还没法设置按钮
代码写在按钮事件里面
双击B列某一单元格,单元格数值自动加1:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Column = 2 Then Target = Target + 1End Sub