#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,327
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a way to make the enter button work as regular enter Ricter Excel Discussion (Misc queries) 1 November 17th 09 02:50 AM
Macro to select cells in column enter data then press enter NP New Users to Excel 1 February 20th 08 04:21 PM
Enter multiple numbers in a cell so total shows when enter keypres newbie Excel Worksheet Functions 2 August 19th 07 12:23 PM
Enter info in one sheet, auto enter in another based on one field The BusyHighLighter[_2_] New Users to Excel 1 August 1st 07 10:54 PM
What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. qwopzxnm Excel Worksheet Functions 2 October 20th 05 09:06 PM


All times are GMT +1. The time now is 06:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"