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

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

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