'类模块代码
Public WithEvents myEvent As MSForms.TextBox
Private Sub myEvent_Change()
Dim s As Double, ctl
For Each ctl In UserForm1.Controls
If ctl.Name Like "*TextBox*" Then s = s + Val(ctl.Text)
Next
UserForm1.Label1.Caption = s
End Sub
'窗体代码
Dim txbs(1 To 4) As New 类1
Private Sub UserForm_Initialize()
Dim i
For i = 1 To UBound(txbs)
Set txbs(i).myEvent = Me.Controls("Textbox" & i)
Next i
End Sub
'类模块代码
Public WithEvents myEvent As MSForms.TextBox
Private Sub myEvent_Change()
UserForm1.Label1.Caption = Me.myEvent.Text
End Sub
'类模块代码
Public WithEvents myEvent As MSForms.TextBox
Private Sub myEvent_Change()
Dim s As Double, ctl
For Each ctl In UserForm1.Controls
If ctl.Name Like "*TextBox*" Then s = s + Val(ctl.Text)
Next
UserForm1.Label1.Caption = s
End Sub