Private Sub Command1_Click()
On Error Resume Next
Dim mCtrl As Control
For Each mCtrl In Form1
If TypeOf mCtrl Is TextBox Then
If mCtrl.Index = "9" Then
Select Case Right(mCtrl.Name, 1)
Case "1"
mCtrl.Text = "111"
Case "2"
mCtrl.Text = "222"
Case "3"
mCtrl.Text = "333"
End Select
End If
End If
Next mCtrl
End Sub
Private Sub Command1_Click()
Dim mCtrl As Control
For Each mCtrl In Form1
If TypeOf mCtrl Is TextBox Then
If mCtrl.Index = "9" Then
Select Case Right(mCtrl.Name, 1)
Case "1"
mCtrl.Text = "111"
Case "2"
mCtrl.Text = "222"
Case "3"
mCtrl.Text = "333"
End Select
End If
End If
Next mCtrl
End Sub
If Me.Controls(i - 1).Name = "Text1" _
Or Me.Controls(i - 1).Name = "Text2" _
Or Me.Controls(i - 1).Name = "Text3" Then
Me.Controls(i - 1).Text = ""
End If