ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Intercepting a Tab on Entry (https://www.excelbanter.com/excel-programming/313698-intercepting-tab-entry.html)

Marston

Intercepting a Tab on Entry
 
I'm using ActiveCell to make determination of certain actions to take
in a tool.

What I've discovered is that if the user makes an entry into a cell
and hits the Tab key rather than the Enter key, it puts me into a
different cell and a different, undesired action.

How can I intercept the Tab and turn it into a shift?

Thanks in advance.

Marston

PS - has anyone else noticed that the Beta version of Google groups is
no longer updating as frequently as before. I used to be 10-15
minutes, but now I'm not seeing anything for days.

Tom Ogilvy

Intercepting a Tab on Entry
 
If you are using one of the events, use the Target argument rather than
ActiveCell.

--
Regards,
Tom Ogilvy


"Marston" wrote in message
om...
I'm using ActiveCell to make determination of certain actions to take
in a tool.

What I've discovered is that if the user makes an entry into a cell
and hits the Tab key rather than the Enter key, it puts me into a
different cell and a different, undesired action.

How can I intercept the Tab and turn it into a shift?

Thanks in advance.

Marston

PS - has anyone else noticed that the Beta version of Google groups is
no longer updating as frequently as before. I used to be 10-15
minutes, but now I'm not seeing anything for days.





All times are GMT +1. The time now is 03:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com