Posted 18 July 2018, 4:21 am EST
Hello,
My application requires that when the Enter key is pressed on a cell the entry just made is accepted and the cell to the right is then selected. I initially used the _KeyDown event but couldn’t get it to work. Looking in this forum it was suggested to use keyboard mapping. I implemented a keyboard mapping function for the Enter key to call my Event Handler which selects the cell to the right. However, when I select a cell, type a number and press Enter the the cell to the right is selected but the number is not accepted and my _EditEnd Event handler is not invoked. Is there a way to map the Enter key to invoke the _EditEnd and then invoke my EventHandler? Mapping the Enter key to the CommitInputNavigationTabNext causes an exception if my other keyboard mapping is present. I need for the number to be accepted and the cursor to move to the right when the Enter key is pressed. And if the end of the sheet is reached the cursor needs to skip a couple of rows and be positioned on the 4th row 1st column.
Thanks,
Luis