Cancel exit event execution

rgjabali · Apr 10th, 2002, 06:55 AM

How can I cancel a code execution attached to an exit event of a texbox.

I want the focus to remain on the textbox which originated the exit event.

Tks

Dave Hawley · Apr 10th, 2002, 07:06 AM

Hi

Do you mean:

Code:

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
   If Not IsNumeric(TextBox1.Value) Then
           MsgBox "Only Numbers Please"
   End If
End Sub

Apr 10th, 2002, 07:06 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Do you mean: Code: Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) If Not IsNumeric(TextBox1.Value) Then MsgBox "Only Numbers Please" End If End Sub

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 10th, 2002, 06:55 AM	#1
rgjabali New Member Join Date: Apr 2002 Posts: 9	How can I cancel a code execution attached to an exit event of a texbox. I want the focus to remain on the textbox which originated the exit event. Tks