Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 date entry: Cannot get away from d-m-yy entry format | Excel Discussion (Misc queries) | |||
Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
intercepting password routines | Excel Programming | |||
Intercepting Paste Function | Excel Programming |