LostFocus VBA Form Events not firing and SetFocus method also not working

[RainerGaier]

I would appreciate it if anybody is able to shed some light as to why these two issues occur ... I also recognize that they may not be related in any way but both are occurring

I have tried a very simple form with two Text fields (TextBox1 & TextBox2) and added the code below ...

Private Sub TextBox1_LostFocus()
MsgBox "Moving off TextBox1"
End Sub

Private Sub TextBox1_AfterUpdate()
MsgBox "Updated TextBox1"
TextBox1.SetFocus
End Sub

The first event never fires when I switch between the two fields.
I get the second message after entering data in TextBox1. So the AfterUpdate event fires.
However, the SetFocus doesn't position the cursor back at the first field.

Thanks in advance.

 

[RoryA]

A textbox on a userform doesn't have a LostFocus event.

The second one actually does set the focus but that happens prior to exiting the control based on user actions. If you want to prevent the user exiting, you would use the Exit or BeforeUpdate events, which both provide a Cancel argument.

 

[RainerGaier]

It's good to learn new things from the more experienced. Appreciated!