Hi. I'm looking for help with a commandbutton I have in a Userform that doesn't show the click/down state when using Enter key.
It is a simple OK button for logging in with username/password with code in the ButtonOK_Click sub of the userform. I have it set as the default button so that you can hit Enter and it activates the OK button.
Unfortunately, when you use the Enter button (whether you tab around and set the focus on the OK button or not), it doesn't show the button changing like it's been pressed or pushed down. I would like for the button to show this when you hit Enter, so that it looks like it does when you mouse click it.
Any help is greatly appreciated. I've tried adding do events as the first line of the ButtonOK_Click subroutine, but that doesn't help.
It is a simple OK button for logging in with username/password with code in the ButtonOK_Click sub of the userform. I have it set as the default button so that you can hit Enter and it activates the OK button.
Unfortunately, when you use the Enter button (whether you tab around and set the focus on the OK button or not), it doesn't show the button changing like it's been pressed or pushed down. I would like for the button to show this when you hit Enter, so that it looks like it does when you mouse click it.
Any help is greatly appreciated. I've tried adding do events as the first line of the ButtonOK_Click subroutine, but that doesn't help.
