how to set a tab order in Excel 2003 for PC? (go cell to cell)
 

Does anybody know how to set a "tab order" in Excel 2003 for PC? I'm not
talking about just tabbing from left to right, but how to set a custom tab
order -- to tab to a pre-designated cell.

thanx,
Cliff
San Francisco

how to set a tab order in Excel 2003 for PC? (go cell to cell)
 

Right click sheet tabview code insert thistest and modify to suit.
OR unlock desired cellsprotect sheetuse tab key

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range("a3").Address Then Range("b3").Select
If Target.Address = Range("b3").Address Then Range("b13").Select
'etc
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"SFTaxMan" wrote in message
...
Does anybody know how to set a "tab order" in Excel 2003 for PC? I'm not
talking about just tabbing from left to right, but how to set a custom tab
order -- to tab to a pre-designated cell.

thanx,
Cliff
San Francisco

how to set a tab order in Excel 2003 for PC? (go cell to cell)
 

Starting with the last cell first, and then onto the first, select all your
cells in order and then just give that selection a name. Select the name
when required and just start entering data

Regards
Ken.......................


"SFTaxMan" wrote in message
...
Does anybody know how to set a "tab order" in Excel 2003 for PC? I'm not
talking about just tabbing from left to right, but how to set a custom tab
order -- to tab to a pre-designated cell.

thanx,
Cliff
San Francisco