Tab command

[skrimpy]

Does anyone know if there a way to code a "tab" command such that no matter where the active cell is I can tab to the next immediate cell? Or do I have to specify which cell is the active cell? My macro moves the active cell around the page according to the contents of specific cells, but in some instances I will need the active cell to tab to the right without knowledge of what the coordinates of the active cell are.

[Nazguy]

Yes, its possible. Use the Selection_Change event for the worksheet you're using. Keep track of the current cell the user is editing in a variable so that you know where they were last because when this event fires the target.address will be the cell that Excel moved the focus to after they pressed enter (which you don't care about). You can then pass the cell/range they were editing when they finished editing it and determine which cell/range you want to activate next based on whatever conditions. So if you stored this in a variable currentRange you can easily activate the new range using Range(currentRange).Activate.

Using this methodology you will always know where the user was last.