VBA实现长按Command Button类似Spin Button连续触发的方法

持续按住鼠标操作Spin Button时，数值会持续递增，但Command Button需要反复点击才能触发对应逻辑。如何设置才能让Command Button实现和Spin Button一致的长按连续触发效果？
现有相关代码如下：

Private Sub CommandButton2_Click()
Label1.Caption = Int(Label1.Caption) + 10
End Sub

Private Sub spbSpinButton_Change()
spbSpinButton.Min = 100
spbSpinButton.Max = 200
spbSpinButton.SmallChange = 10
Label1.Caption = spbSpinButton.Value
End Sub

Command Button无内置长按连续触发属性，可通过鼠标按下/抬起事件搭配Windows API计时器实现该效果，操作步骤如下：

• 第一步：在窗体代码顶部声明API函数与模块级变量

' Windows API计时器函数声明
Private Declare Function SetTimer Lib "user32" (ByVal hWnd As Long, ByVal nIDEvent As Long, ByVal uElapse As Long, ByVal lpTimerFunc As Long) As Long
Private Declare Function KillTimer Lib "user32" (ByVal hWnd As Long, ByVal nIDEvent As Long) As Long

' 模块级参数
Private isBtnPressed As Boolean
Private timerID As Long
Private Const TRIGGER_INTERVAL As Long = 150 ' 长按触发间隔，单位毫秒，数值越小触发速度越快

• 第二步：在窗体代码中编写按钮事件与数值更新逻辑，替换原有CommandButton2_Click事件

' 鼠标按下时启动连续触发
Private Sub CommandButton2_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
    isBtnPressed = True
    ' 首次按下立即执行一次，消除触发延迟
    UpdateValue
    ' 启动计时器按固定间隔重复执行逻辑
    timerID = SetTimer(0, 0, TRIGGER_INTERVAL, AddressOf TimerProc)
End Sub

' 鼠标抬起时终止连续触发
Private Sub CommandButton2_MouseUp(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
    isBtnPressed = False
    KillTimer 0, timerID
End Sub

' 抽离需要重复执行的业务逻辑
Private Sub UpdateValue()
    Label1.Caption = Int(Label1.Caption) + 10
    ' 如需和Spin Button保持一致的数值范围限制，可放开下方注释
    ' If Label1.Caption > 200 Then Label1.Caption = 200
    ' If Label1.Caption < 100 Then Label1.Caption = 100
End Sub

• 第三步：插入一个标准模块，在模块内编写计时器回调函数

' 标准模块代码，注意将UserForm1替换为你实际使用的窗体名称
Public Sub TimerProc(ByVal hWnd As Long, ByVal uMsg As Long, ByVal idEvent As Long, ByVal dwTime As Long)
    UserForm1.UpdateValue
End Sub

• 交互调整说明：如果需要模拟原生控件“按住后先等待短时间再开始连续触发”的手感，可在MouseDown事件启动计时器前添加对应时长的等待逻辑即可。

内容的提问来源于stack exchange，提问作者Bhavesh Shaha