ENTER key
 

Hi All;
It seems that VBA treats ENTER key on keyboard and on
keypad differently for the purpose of
Application.OnKey "{ENTER}". Keyboard is captured and
keypad is not. Who knows proper mimic for the keypad?

Irek

ENTER key
 

From the VBA help

ENTER ~ (tilde)
ENTER (numeric keypad) {ENTER}


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"irek" wrote in message ...
Hi All;
It seems that VBA treats ENTER key on keyboard and on
keypad differently for the purpose of
Application.OnKey "{ENTER}". Keyboard is captured and
keypad is not. Who knows proper mimic for the keypad?

Irek

ENTER key
 

ENTER (numeric keypad) {ENTER}
ENTER ~ (tilde)

(from VBA help)

--
HTH. Best wishes Harald
Followup to newsgroup only please.

"irek" wrote in message
...
Hi All;
It seems that VBA treats ENTER key on keyboard and on
keypad differently for the purpose of
Application.OnKey "{ENTER}". Keyboard is captured and
keypad is not. Who knows proper mimic for the keypad?

Irek

ENTER key
 

thx guys;
Irek
"irek" wrote in message
...
Hi All;
It seems that VBA treats ENTER key on keyboard and on
keypad differently for the purpose of
Application.OnKey "{ENTER}". Keyboard is captured and
keypad is not. Who knows proper mimic for the keypad?

Irek