Caps Lock

[Coolmo]

Is there any way to access the Caps Lock switch from VBA?

[RobertB]

I thought there was something in the Exchange. Check there.

[jwanstaett]

you can use the window api to get the state of the cap lock




Public Declare Function GetKeyState Lib "user32" (ByVal nVirtKey As Long) As Integer
Public Const VK_CAPITAL = &H14

If GetKeyState(VK_CAPITAL) = 0 Then
MsgBox "Caps Lock Is Off", vbOKOnly, "Caps Lock Check by John w Anstaett"
End If

see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wceui40/html/cerefgetkeystate.asp

[Ed Jobe]

I wrote a class that toggles the caps lock whenever you switch applications. If you are interested, I'll dig it up.

[jwanstaett]

I thought there was something in the Exchange. Check there.yes see Exchange EX001163