View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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