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?
|