Excel 2007 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

 

[SkipVought]

hi,

WHERE is your text box?


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[gustaf111]

Hello Skip,

It is on a a excel sheet

Thanks Gustaf

 

[SkipVought]

Where do you see the Exit Event?

Do you see the LostFocus event?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[gustaf111]

I just changed to new excel sheet! And there the LostFocus evnt works! Thanks Skip!

Do you now how to valide the string to a valid date ?

 

[SkipVought]

I do not recommend alloing users to enter dates in a text box. Why not a Date Picker or separate dependent fields for year, month & day?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[gustaf111]

ohh! Okay. What is the reason ?

I will think aboyt it, but I would prefer to input date like: 2011-09-14 .....

 

[SkipVought]

Can you be assured, with certainty that your user(s) will always enter dates that are unambiguous or can be interpreted for validation?

for instance, date string entered in dd-mm-yyyy structure WILL be converted in a manner not expected and dates can also be entered using alpha months.

When have you ever entered a date into a professionally managed system that accepted free form strings? I have not!

I'd use a DatePicker control. SIMPLE!!!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}