Userform Textbox

[Nine Zero]

Hello,

Im wondering why my .SetFocus is not working properly

In the code below i have if the user does not input a valid date, clear the box then i want to setfocus back into that textbox, but what it does is it DOES clear out the textbox but then it just jumps ahead to my next Tab Index ...any ideas

Edit: could it be that my first If statement is exiting the sub after clearing it?

Private Sub startdatebox_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If startdatebox = vbEmptyString Then Exit Sub
If IsDate(startdatebox) Then
    startdatebox = Format(startdatebox, "dd/mm/yyyy")
Else
    MsgBox "Please enter a valid date!" & vbNewLine & vbNewLine & "Remember you must have the forward slashes in your date." _
    & vbNewLine & vbNewLine & "Example: 01/01/2018", vbCritical
    startdatebox.Value = ""
    startdatebox.SetFocus
End If
End Sub

 

[jproffer]

Change the setfocus line to

Cancel=True

 

[Nine Zero]

Change the setfocus line to

Cancel=True

Hmmmm Worked like a charm!

Mind explaining a bit why this works? i know i can google it but i would rather get an explanation from someone that knows it.

Thanks again!

 

[jproffer]

Don't mind at all . I *think* why setfocus don't work, but cancel does is because you're doing it on the exit event (after you've clicked or tabbed into a different textbox...at least that's how I tested it)...and if that code would set the focus back to itself, it wouldn't really have "exited" at all. That's my best guess on that part.

The Cancel=True works because you're cancelling the trigger event (the exit) so it doesn't complete that event...therefore, it stays focused on that textbox.

 

[Nine Zero]

Don't mind at all . I *think* why setfocus don't work, but cancel does is because you're doing it on the exit event (after you've clicked or tabbed into a different textbox...at least that's how I tested it)...and if that code would set the focus back to itself, it wouldn't really have "exited" at all. That's my best guess on that part.

The Cancel=True works because you're cancelling the trigger event (the exit) so it doesn't complete that event...therefore, it stays focused on that textbox.

Ahhhh i see so its like if you were to have an event being ready to trigger like "Are you sure you want to do this?" then you have an OK and a CANCEL button ... if you hit cancel you are just sent back to the previous location which in this case would be the textbox.

Very cool.

Thanks again!

 

[jproffer]

That would just cancel whatever you're asking about with the msgbox, but depending on how you coded it, it might leave the focus on the textbox also...not sure.

I just had another thought about your code above....let me do some playing ...might have a better explanation why setfocus didn't work.

EDIT: Nevermind, it wasn't what I was thinking it might be. My best guess remains unchanged