Change events - Userform Textbox

[Formula11]

Is there a change event for userform textboxes when leaving a textbox, without making a change.
So you select a textbox and then leave it (selecting another textbox), without making any changes or pressing Return.

It's not the following:
- Enter
- AfterUpdate

 

[Fluff]

Have you tried the Exit event?

 

[Formula11]

Yes, I did try this before, but got error.

 

[Fluff]

What was the code?

 

[dmt32]

Does your Exit Event have its parameter like this?

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)

End Sub

Dave

 

[Formula11]

After leaving the textbox, the colour changes to grey.
I think the code by dmt32 is working though. Thanks for this.

Private Sub BoxHeight_AfterUpdate()
    With BoxHeight
        .ForeColor = &HC0C0C0 'Grey
    End With
End Sub

 

[Fluff]

That's not the Exit event.

 

[Formula11]

OK yes that's true.
Thanks to both.