I need to create a loop that doesn't allow the user to leave the textbox
until it is filled. Below is what I have coded for the message box but would
like to include the loop until textbox is filled. Also if possible would
like this field to be visited without the LostFocus aspect of it. Any
Suggestions?

Private Sub Textbox8_LostFocus()
If TextBox8 = "" Then
MsgBox "Please enter Submitting Agency Name"
Exit Sub
End If
End Sub