Events For Text Box To Get Focus

[jo15765]

I am using the

textbox1_Enter()

event which fires when the text box is entered, but how can I account for if the data in the text box is cleared?

What I am after is anytime the text box is clicked, or cleared have a message box pop-up. What would be the best way tod o this?

 

[RoryA]

You can use the Change event and test for "" as the value.

 

[jo15765]

Is the vba for that simply

textbox1_Change()

 

[shg]

In the VBE in the code module for the form, if you select the control in the left dropdown, the right dropdown shows the events for the control and will create the signature for the event handler.

 

[jo15765]

In the VBE in the code module for the form, if you select the control in the left dropdown, the right dropdown shows the events for the control and will create the signature for the event handler.

Very interesting, I had forgotten about this feature as I have been away from Excel VBA dev lately.

 

[shg]

You're welcome.