KeyCode Conversion

joatmon · #1 06-03-2012, 06:50 PM

I have a textbox on a userform that I am trying to work with the KeyDown event. I'm trying to capture the user's input using the KeyCode. I thought that KeyCode would just return ASCII values, but this is proving not to be the case. Take this very simple code for illustration:

Code:

Private Sub txtAnswer_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
    MsgBox (KeyCode)
End Sub

If I enter the number "3" on the keyboard, what comes out is the number 99. I was expecting the number 51 to appear since that is the ASCII value for the character "3".

Can anybody explain this behavior to me? It's probably pretty simple, but I don't know how to translate this.

Thank you!

Colin Legg · #2 06-06-2012, 05:18 AM

Your code returns 51 for me. I saw that you've posted a subsequent question on another thread which suggests that you've found a solution to this. Did you resolve this issue and, if so, what was the cause of the problem and how did you fix it?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ost to pst conversion	rudihorvath	Outlook	0	03-16-2012 07:23 AM
utm to long lat conversion	gsrikanth	Excel	2	01-17-2012 07:29 AM
Multiple conversion	Metamag	Word	3	06-20-2011 05:03 PM
pdf to word conversion	wordpdf	Word	3	05-15-2011 01:58 PM
file conversion ?	coltheplumb	Excel	1	05-12-2011 01:03 PM