1. this generator is based on Lavolpe's code in here: VBA-Control-Arrays-Imitation-Classes
2. Generator Usage
(1) create a blank class in vba ide
(2) input "Private WithEvents ooo as MSForms.TextBox"
(3) click events combobox to implement all the events of the control
(4) copy whole code of the class
(5) execute this generator to get 3 class files in "code" folder
3. Code Usage
(1) Import 3 class files in "code" folder to current vba project
(2) write code
'in userform
private withevents c as clsTextBoxList
Private Sub UserForm_Initialize()
Set c = New clsTextBoxList
c.Add Me.TextBox1
c.Add Me.TextBox2
c.Add Me.TextBox3
End Sub
Private Sub UserForm_Terminate()
Set c = Nothing
End Sub
Private Sub c_Change(oTextBox As MSForms.TextBox)
MsgBox oTextBox.Text
End Sub

'or in worksheet
private withevents c as clsTextBoxList

Private Sub Worksheet_Activate()
Set c = New clsTextBoxList
c.Add Me.TextBox1
c.Add Me.TextBox2
c.Add Me.TextBox3
End Sub

Private Sub Worksheet_Deactivate()
Set c = Nothing
End Sub

Private Sub c_Change(oTextBox As MSForms.TextBox)
MsgBox oTextBox.Text
End Sub