'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 |
|---|
