Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ascii key value
Hello,
I am designing an application in VBA which will utilize userforms as data entry interfaces. For the ease of use, I have decided on utilize KeyDown event in some of the textbox controls, in order to automatically format the text. For instance, a typed numbers for a phone number 8001113333 will automatically render it to be 800 111 3333. I understand that I could very easily use the "format" method to achieve the same. However this way each character gets formatted before the change is actually made. My only problem is such that the KeyCode argument of the KeyDown event returns values of 48 through 57 for the keys above the letters, but 96 through 105 for the numlock keys. Unfortunately the latter ones correspond to letters instead. Could someone point me in the right direction, please? I'm not sure how to approach this issue. Thank you, Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ascii key value
On Dec 24, 6:40*pm, maroosh wrote:
Hello, I am designing an application in VBA which will utilize userforms as data entry interfaces. *For the ease of use, I have decided on utilize KeyDown event in some of the textbox controls, in order to automatically format the text. *For instance, a typed numbers for a phone number 8001113333 will automatically render it to be 800 111 3333. *I understand that I could very easily use the "format" method to achieve the same. *However this way each character gets formatted before the change is actually made. *My only problem is such that the KeyCode argument of the KeyDown event returns values of 48 through 57 for the keys above the letters, but 96 through 105 for the numlock keys. *Unfortunately the latter ones correspond to letters instead. Could someone point me in the right direction, please? *I'm not sure how to approach this issue. Thank you, Mark Please disregard. There couldn't be an easier solution. I guess I just got a little bit too tired. :) Best regards, Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CSV to ASCII | Excel Discussion (Misc queries) | |||
VBA - Hex To ASCII | Excel Programming | |||
ASCII format | Excel Discussion (Misc queries) | |||
Ascii | Excel Programming | |||
ASCII value | Excel Programming |