Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW DO I PROGRAM THE TAB KEY TO MOVE IN SPECFIC ORDER?
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
move a row of data values to a column in sorted order | Excel Discussion (Misc queries) | |||
add on date specfic | Excel Worksheet Functions | |||
move data to order sheet | Excel Discussion (Misc queries) | |||
move excel program from old computer to new | Excel Discussion (Misc queries) | |||
sort rows in alphabetical order and move the corresponding data | Excel Worksheet Functions |