ExcelBanter - Events for Enter/Exit Textboxes on Userforms

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Events for Enter/Exit Textboxes on Userforms (https://www.excelbanter.com/excel-programming/373424-events-enter-exit-textboxes-userforms.html)

John Fuller

Events for Enter/Exit Textboxes on Userforms

Are there events that trigger when the focus Enters/Exits a Textbox?
If so, what are they?

Thanks,
John

Die_Another_Day

Events for Enter/Exit Textboxes on Userforms

Private Sub TextBox1_Enter()

End Sub

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)

End Sub

HTH

Charles

John Fuller wrote:
Are there events that trigger when the focus Enters/Exits a Textbox?
If so, what are they?

Thanks,
John

John Fuller

Events for Enter/Exit Textboxes on Userforms

I guess I should have known it would be that simple. *Smacks Self*

Thanks

Die_Another_Day wrote:
Private Sub TextBox1_Enter()

End Sub

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)

End Sub

HTH

Charles

John Fuller wrote:
Are there events that trigger when the focus Enters/Exits a Textbox?
If so, what are they?

Thanks,
John

All times are GMT +1. The time now is 10:29 AM.