Shift + Tab help

[paveitcans]

Good Morning, I have the code below in a worksheet to set the tab order. What I'm trying to do is enable it to use the Shift + Tab to "back up" in the sheet. Has anyone had any luck with this? Any help would be greatly appreciated.


Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Select Case lastcell
Case "a1"
Range("e2").Select
lastcell = "e2"
Case "e2"
Range("e4").Select
lastcell = "e4"
Case "e4"
Range("e6").Select
lastcell = "e6"
Case "e6"

 

[Bruno_x]

another approach
1) protect all the cells except the cells to want to use (A1, E2, E4, etc.)
format-->cells-->protection-->uncheck locked
2) protect the sheet
tools-->protection-->protect sheet

With TAB you can jump to the next cell, with Shift+TAB to the previous cell

 

[paveitcans]

Thanks Bruno, I chose not to do this since the cells that I need are not "in order". For example, had I attached more code you would see that it tabs from e4 to e6,e8,b10,g8,b12. It jumps all over the place.