Hi,
I assume you left thos 100 Textbox(s) (Name) default. If so you can acheive this by writing a simple VBA macro code like mentioned below. If the value is not numeric this pops the name of the textbox. you can change the funcionality which suits for you.
Private Sub CheckIsNumeric()
Dim i As Integer
Dim flag As Boolean
For i = 1 To 100
flag = IsNumeric(Controls("TextBox" & i).Text)
If flag = False Then
MsgBox ("TextBox" & i & " is not numeric")
Exit For
End If
Next
End Sub
Hope I understood your question correctly. Change the value 100 based on your textbox count.
Thanks
Sriram.B