Add event listener to Excel Textbox (lose focus)

Question

I need to fire an sub or a command when a user is done using a text box in Excel. I have tried using the AfterUpdate() event and the LoseFocus() event like this: ``` Public Sub Kommentar_AfterUpdate() MsgBox ("Hurray") End Sub ``` The text box is named `Kommentar` and is inside the sheet `Radio`. Also, where is the code supposed to be written? i have tried placing it in code sheet for the Radio sheet, and in a separate module. Any tip, hint or answer is appreciated!

Accepted Answer

For embedded ActiveX Excel control - add the following in the sheet mobile in VBA. TextBox1 is the name of the control:

```
Private Sub TextBox1_LostFocus()

End Sub
```

For userform - use the following where Textbox1 is the name of your textbox:

```
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)

End Sub
```

You can set the Cancel bool to True if you do not want to lose focus from the textbox. In addition the code is placed within the UserForm >> Right Click >> View Code.

Add event listener to Excel Textbox (lose focus)

Solution

Problem