Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
focus | Excel Discussion (Misc queries) | |||
RTD Getting The Focus | Excel Programming | |||
Focus | Excel Programming | |||
focus | Excel Programming | |||
set focus | Excel Programming |