类模块:
Public WithEvents spb As MSForms.SpinButton
Dim num As Integer
Private Sub spb_SpinUp()
MsgBox 1
End Sub
模块:
Dim arr(12) As New SpbClass
Sub NewButton()
Dim i
For i = 0 To 11
Set arr(i).spb = UserForm1.Controls("SpinButton" & i + 1)
arr(i).spb.Max = 10
arr(i).spb.Min = 0
Next
End Sub