View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
HotRod HotRod is offline
external usenet poster
 
Posts: 147
Default 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.