Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trap whether it was TAB or arrow keys etc
Is it possible to determine how a user exited a cell? I can track the last
cell address and new cell address but that doesn't tell me whether they tabbed through the cell or clicked out. I want to set a default value for columns and if the user TAB's through or presses the space bar and then TAB's over I want to complete the cell with the default value. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trap whether it was TAB or arrow keys etc
There might be some API that would give you that information but I can't
think how to implement to your requirement. That aside I don't think it's possible, if I'm wrong you can be pretty sure someone will step in. Does it have to be a keyboard movement. You say you already have a method to store the last selected cell, so why not compare it's address with the next selected cell. If it's adjacent, and within the range you want to treat, then treat it as if were selected with keyboard arrow or tab. Something to bear in mind, if user tabs through a multicell selection, a selection-change event is not triggered. However a change event is triggered if tab or enter is used to complete the entry of the last active cell. But note, the target cell that's returned in the event is the new active cell, not the cell that's just changed. Confused! Regards, Peter T "HotRod" wrote in message ... Is it possible to determine how a user exited a cell? I can track the last cell address and new cell address but that doesn't tell me whether they tabbed through the cell or clicked out. I want to set a default value for columns and if the user TAB's through or presses the space bar and then TAB's over I want to complete the cell with the default value. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trap whether it was TAB or arrow keys etc
I've worked around this by having the user enter a "space" in the cell and
then continue on. Entering a space will enter the default value for that column. Quick other question I'm hoping you can help with when I use "Target.Column" I get the number "1" how do I use the number to reference a cell at A12 with the worksheets("mysheet").range().value ??? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trap whether it was TAB or arrow keys etc
rw = 12
col = Target.column msgbox Worksheets("mysheet").Cells(rw,col).Value -- Regards, Tom Ogilvy "HotRod" wrote in message ... I've worked around this by having the user enter a "space" in the cell and then continue on. Entering a space will enter the default value for that column. Quick other question I'm hoping you can help with when I use "Target.Column" I get the number "1" how do I use the number to reference a cell at A12 with the worksheets("mysheet").range().value ??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arrow Keys | Excel Discussion (Misc queries) | |||
Using arrow keys | Excel Discussion (Misc queries) | |||
Arrow Keys | Excel Discussion (Misc queries) | |||
Arrow keys | Excel Discussion (Misc queries) | |||
arrow keys | Excel Discussion (Misc queries) |