'Textbox using Exit and Command Button not clicking only gets selected

First time posting. I'm having an issue, I wrote a simple VBA Userform with a textbox and command button that changes color when clicked.

My textbox command...

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) Sheets("Sheet1").Range("A1") = TextBox1.Text
End Sub

I use Exit instead of Change cause change slows down the excel program.

Private Sub TextBox1_Change()
Sheets("Sheet1").Range("A1") = TextBox1.Text
End Sub

The problem is after typing and mouse clicking the command button, the command button gets selected and does not click and change its color. Somehow using Exit instead of change the mouse click does not click the command button.

Could anyone please help me with this issue its frustrating.

Thank you a lot.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source