Textbox exit event does not work

[gustaf111]

Hello,

I can not get the Exit event on a textbox working on Excel 2007.

Private Sub TextBox1_Exit()
MsgBox ("Test")
End Sub

I would like to validate that the input in the textbox is a valid date, are there any system functions ?

Thanks Gustaf

 

[mikerickson]

I often have problems with the Exit event.
For data validation, the BeforeUpdate event is sweet. (Especialy with the Cancel argument)

 

[gustaf111]

Thanks! But it does not work either

Private Sub TextBox1_BeforeUpdate()
MsgBox ("Test")
End Sub

 

[Norie]

Where is the textbox located?

 

[gustaf111]

It is loacted on a excel sheet. The Change event works.

 

[mikerickson]

For an ActiveX Textbox on a worksheet, its the LoseFocus event not the Exit event.