View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Green[_4_] John Green[_4_] is offline
external usenet poster
 
Posts: 47
Default HOW DO I PROGRAM THE TAB KEY TO MOVE IN SPECFIC ORDER?

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


"COWBOY" wrote in message
...
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?