Hello,
I have some code that creates an input box for inputting a password and if the password is incorrect a message box is created (see code below). It would be good to have some additional vba that detects at this point whether the CAPS LOCK is on and then give a second message to the user letting them know that the CAPS LOCK is 'on'. Can this be achieved?
Any help much appreciated.
I have some code that creates an input box for inputting a password and if the password is incorrect a message box is created (see code below). It would be good to have some additional vba that detects at this point whether the CAPS LOCK is on and then give a second message to the user letting them know that the CAPS LOCK is 'on'. Can this be achieved?
Any help much appreciated.
VBA Code:
If Len(sErrors) > 0 Then MsgBox "Incorrect password for:" & sErrors, vbOKOnly