OnKey gives all capital letters?

Hey gurus,
I'm trying to use Application.OnKey commands for upper and lower case letters, but it seems like Excel always uses upper case letters (chars 65 to 90) rather than using lower case letters (chars 97 to 122).

To be more specific: When I activate OnKey calls for all letters (65:90 and 97:122) and I press a lower case letter such as "e" I should get the character number 101, but instead I get the character number 69.

Can anyone shed some light on this?

Public Sub KeyEventOn()
    Dim iCount As Integer 'index for ASCII characters
    For iCount = 65 To 90
        Application.OnKey "{" & iCount & "}", "'MySub """ & iCount & """'"
    Next
    For iCount = 97 To 122
        Application.OnKey "{" & iCount & "}", "'MySub """ & iCount & """'"
    Next
End Sub




Public Sub KeyEventOff()
Dim iCount As Integer 'index for ASCII characters
    For iCount = 65 To 90
        Application.OnKey "{" & iCount & "}"
    Next
    For iCount = 97 To 122
        Application.OnKey "{" & iCount & "}"
    Next
End Sub


Public Sub MySub(ByVal KeyCode As Long)
    MsgBox KeyCode
end sub

Re: OnKey gives all capital letters?

rory, thank you for the clarification. Glad to know it's a "feature", not a bug.

royUK, the point of my code is a bit beyond what I want to explain right now. I'll find a workaround for this section, if and when I get stuck I'll post again. I just don't want to use up valuable Guru time for sections that I know I can figure out myself. I really appreciate the willingness of people on this forum to help and I don't want to abuse their time.

cheers!