Textbox/Userform question
Try:
If textbox1.value = "" Then
textbox1.setfocus
Exit Sub
ElseIf textbox2.value = "" Then
textbox2.setfocus
Exit Sub
ElseIf textbox3.value = "" Then
textbox3.setfocus
Exit Sub
End If
Let me know if you have any problems.
Mark
Stuart wrote:
If I show a form which has 3 crucial textboxes that must
have user data in them.....can I return them to an empty
textbox before they are permitted to exit?
Maybe something like Select Case?
Regards.
|