Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieve focus After Update
How can I set the focus back to the control after "After Update" validation?
Thanks in advance. If Not IsNumeric(TxtPhone.Value) And TxtPhone.Value < vbNullString Then MsgBox "Sorry, only numbers allowed" TxtPhone.Value = vbNullString TxtPhone.SetFocus End If If Len(TxtPhone.Value) < 10 Then MsgBox "Please enter the phone number including area code" TxtPhone.Value = vbNullString TxtPhone.SetFocus Exit Sub Else TxtPhone.Value = Format(TxtPhone.Value, "(###) ###-####") End If |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop Excel's UPDATE\Don't UPDATE message box from appearing every time I open the work book | Excel Programming | |||
Data Validation lists update orginal cell with list update | Excel Worksheet Functions | |||
Excel 2003 - Update or Don't Update Links Problem | Excel Programming | |||
Retrieve and update 1 record at a time | Excel Programming | |||
retrieve and update data from a dbf file | Excel Programming |