You need a class module. Enter and Exit events for TextBoxes are not reliable in a class module environment. Because your textboxes are on a userform, they do not support the GotFocus event as an embedded activex textbox would.
For a workaround and as an example of class modules, in the VBE, insert a new class module and acept its default name of New Class 1. Paste this code into it:
Option Explicit
Public WithEvents TxtGroup As MSForms.TextBox
Private Sub TxtGroup_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
MsgBox "You clicked the text box named " & TxtGroup.Name
End Sub
Private Sub TxtGroup_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
MsgBox "You used the keyboard to exit from the text box named " & TxtGroup.Name
End Sub
Private Sub TxtGroup_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
On Error Resume Next
With TxtGroup
Select Case KeyAscii
Case 46, 48 To 57
Case Else
KeyAscii = 0
MsgBox "Only numbers are allowed.", 48, "That character is not allowed."
End Select
End With
End Sub
In the userform module, paste in this code:
Option Explicit
Dim txtBoxes(1 To 80) As New Class1
Private Sub UserForm_Initialize()
Dim i As Integer
For i = 1 To 80
Set txtBoxes(i).TxtGroup = Me.Controls("TextBox" & i)
Next i
End Sub
Now return to the worksheet and call your userform. The code as is will be somewhat annoying practically, remember, these are just examples of events. The MouseDown event will make a message box pop up when you click on the textbox but that will not select it. With the KeyDown event, you can select a textbox using the tab key, and when you do, it will make a message box pop up telling you what the name of that text box is you just exited. The KeyPress event is an example of what I use in my clients' apps for textboxes where only numbers are allowed, and I have a lot of textboxes, hence a class module like this.
Note, the "80" in code is there because you said 80. Modify as needed, depending on naming syntax of your textboxes if they are not named as "TextBox" & number .
Also note as I said, practically, these events would not all be in place, they are just examples. As is, if you enter a non-didgit character, you will get two message boxes. Therefore, add or delete events from the class module for that TxtGroup class as are appropriate for your app.