Jump certain columns with tab

[Guest]

This needs to only apply to rows 1-56 & 60-66 only. x represents the row #

I would like to go from Ax to Cx while tabbing through a spreadsheet, is
this possible? Although, I need to be able to edit Bx by selecting it with
the mouse.

 

[Guest]

Yes ! Use the function below. Two is the number of columns to move to the
right. Then go to Tools - Macro - Options. Select a Key to run the macro.
Now when you use the short cut key it will move two columns to the right.



Sub moveright()

ActiveCell.Offset(0, 2).Select

End Sub

 

[Guest]

I am not that familiar with macros. The extent of my use is coping a few into
visual basic. What exactly do I need to do? Thank you for your help. Also, I
am using Excel 2007.

 

[Gord Dibben]

That macro wouldn't perform as you want in any case.

Each time it is run it jumps two cells to the right but doesn't go back to
column A, just keeps on jumping across the sheet.

See Bob Phillips' site for methods of tabbing to cells in order.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

In your case, the named range may be the best way to go.

If you use the protection method, you will have to deal with editing in column B
in some way......possibly an unprotect/protect macro for when you want to edit
in B


Gord Dibben MS Excel MVP

 

[Gord Dibben]

If you are interested in a VBA method, this is quite easy to implement.

This event code does as you want.

Jumps from A1 to C1 then back to A2 then to C2 etc. but allows editing in any
cell.

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo endit
If Target.Column = 1 Then
Application.EnableEvents = False
Target.Offset(0, 2).Select
End If
If Target.Column = 3 Then
Target.Offset(1, -2).Select
End If
endit:
Application.EnableEvents = True
End Sub

This is sheet event code. Right-click on the sheet tab and "View Code".

Copy/paste into that module.


Gord