Thread: Focus
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] streamaxi@gmail.com is offline
external usenet poster
 
Posts: 16
Default Focus

I have a textbox for putting in Employee ID. The moment I enter the
employee ID and tab out of the control, there is a validation being
done. If it is an invalid ID, I get the message box but the curor moves
to the next control. How can I take it back?

If Len(aEmpID.Value) < 5 Or Not IsNumeric(aEmpID.Value) Or check =
False Then
MsgBox "Incorrect Employee ID"
aEmpID = Empty
aEmpID.SetFocus
End If

SetFocus is not working for me. Is there any other syntax?