HOW DO I PROGRAM THE TAB KEY TO MOVE IN SPECFIC ORDER?

[Guest]

EXCEL 2003: TRYING TO CREATE A FORM, USING TAB KEY TO MOVE FROM UNLOCK CELL
TO ANOTHER UNLOCK CELL TO INPUT DATA IN A PROTECTED WORKSHEET, INSTEAD OF
JUST MOVING TO THE UNLOCK CELL TO THE RIGHT OR DOWN, I WANT TO SET A SPECFIC
ORDER SO WHEN YOU USE TAB KEY IT WILL MOVE IN THAT ORDER, CAN THIS BE DONE?

 

[John Green]

You could use something like the following code.

Sub SetKey()
Application.OnKey "{Tab}", "myMacro"
End Sub

Sub myMacro()
Select Case ActiveCell.Address
Case "$A$1"
Range("E1").Select
Case "$E$1"
Range("C1").Select
Case "$C$1"
Range("A1").Select
Case Else
Range("A1").Select
End Select
End Sub

SetKey assigns the myMacro code to the Tab key. The Tab key will then select
cells as specified.

--
John Green
Sydney
Australia

EXCEL 2003: TRYING TO CREATE A FORM, USING TAB KEY TO MOVE FROM UNLOCK CELL
TO ANOTHER UNLOCK CELL TO INPUT DATA IN A PROTECTED WORKSHEET, INSTEAD OF
JUST MOVING TO THE UNLOCK CELL TO THE RIGHT OR DOWN, I WANT TO SET A SPECFIC
ORDER SO WHEN YOU USE TAB KEY IT WILL MOVE IN THAT ORDER, CAN THIS BE

DONE?