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

On Dec 24, 6:40*pm, maroosh <maru...@hotmail.com> 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