A suggestion:
For checking empty textboxes, check it's length....:
Code:
If len(Textname(Index).Text) = 0 Then
Because, if there is a space, then your checking condition won't be going to work...