Navigating in Userform

[lpekerman]

Hello;

I have a userform with many fields.
Some of them have controls; example if Trade Date is entered as TODAY, not 12/22/05 then a message appears.

What I want to do is: the user enters the info with an error, tabs, the message shows up and then the curser goes back to the field that was entered;
I tried "afterupdate" and "setfocus" that did not work

thanks

 

[combo]

Try 'Exit' event with 'Cancel' parameter.

combo

 

[Firery]

With a TextBox control, this will stop the user exiting the control if the wrong value is entered.
It should give you the idea.


Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If TextBox1.Value < 50 Then
Cancel = True
Else
'Any other Code you like
End If
End Sub