View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
helpless in iowa[_2_] helpless in iowa[_2_] is offline
external usenet poster
 
Posts: 3
Default MSG BOX PREVENTS SET FOCUS POST 2

If msg box line is removed from code, text box will be the focus and text
selected. With MSG BOX line left in, its like it just skips the focus and
highlight code

Private Sub txtphone_Change()
If Not IsNumeric(txtphone) Then
MsgBox "Must be Numeric"
txtphone.SetFocus
txtphone.SelStart = 0
txtphone.SelLength = 1000
End If

End Sub