tab order

[isma786]

Hi

I have a protected spreadsheet with user input into cells F5, D827 and L3 at the moment the user inputs into F5 then presses tab which takes him to D8, D9 etc then L3. I would like the user to input into F5 the tab to L3 then D8, D9, etc...

Can this be done?

 

[xlbo]

use the worksheet_CHANGE event

If target.address = "$F$5" then
range("L3").select
end sub
end if
if target.address = "$L$3" then
range("D8").select
end sub
end if

etc etc

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[SkipVought]

Hi,

Just another variation on Geoff's solution

Private Sub Worksheet_Change(ByVal Target As Range)
   With Target
      Select Case .Address
         Case "$F$5": [L3].Select
         Case "$L$3": [D8].Select
      End Select
   End With
End Sub

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884