Make TAB key in cell behave like enter

[lililililili]

Hi,

I have the following problem: I programmed a macro to be triggered whenever I change cell values using worksheet_change. Now, when I enter data with the ENTER key, it works just fine. But when I enter data and istead of pressing enter, I hit TAB, the macro doesn't get triggered....

Do you have any ideas on how excel can identify when I hit the TAB key while the cursor is inside a cell?

[meabrams]

Try This.....

In ThisWorkbook

Please Login or Register  to view this content.

In A Module

Please Login or Register  to view this content.

[Norie]

Code can't be executed when a cell is in edit mode, and it sounds like that might be the case here if the cell isn't being exited when you hit TAB.

Do you have the workbook/worksheet set up so pressing TAB doesn't exit the cell?