Prev: Macro from cell specific to whole column
Next: Sumproduct - Return value as Blank
From: G on 25 May 2010 17:34
I am currently using Excel 2003 and 2007 if necessary.

I would like the ability to configure the excel sheet column sequencing when
I hit the enter key or tab key. Is this possible?? Any suggestions???


Thank You,

G
From: Gord Dibben on 26 May 2010 12:07
If your input cells are in a left to right, top to bottom sequence,
unlocking input cells, protecting sheet and Tabbing to them will work.

If not in that sequence you can create a named range in the order you want.

Start with last cell in order then CTRL + Click your way through the
sequence.

See Bob Phillips' site for more on this.

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

You can also use VBA to tab through a sequence of cells.

Private Sub Worksheet_Change(ByVal Target As Range)
'Anne Troy's taborder event code
Dim aTabOrd As Variant
Dim i As Long

'Set the tab order of input cells
aTabOrd = Array("A5", "B10", "C5", "A10", "B1", "C3") 'adjust to suit

'Loop through the array of cell address
For i = LBound(aTabOrd) To UBound(aTabOrd)
'If the cell that's changed is in the array
If aTabOrd(i) = Target.Address(0, 0) Then
'If the cell that's changed is the last in the array
If i = UBound(aTabOrd) Then
'Select first cell in the array
Me.Range(aTabOrd(LBound(aTabOrd))).Select
Else
'Select next cell in the array
Me.Range(aTabOrd(i + 1)).Select
End If
End If
Next i
End Sub


Gord Dibben MS Excel MVP

On Tue, 25 May 2010 14:34:02 -0700, G <G(a)discussions.microsoft.com> wrote:

>I am currently using Excel 2003 and 2007 if necessary.
>
>I would like the ability to configure the excel sheet column sequencing when
>I hit the enter key or tab key. Is this possible?? Any suggestions???
>
>
>Thank You,
>
>G

From: Jacob Skaria on 27 May 2010 16:56
Not possible using built-in functionalities. If you can elaborate someone
here might be able to help using a VBA solution..

--
Jacob (MVP - Excel)


"G" wrote:

> I am currently using Excel 2003 and 2007 if necessary.
>
> I would like the ability to configure the excel sheet column sequencing when
> I hit the enter key or tab key. Is this possible?? Any suggestions???
>
>
> Thank You,
>
> G
 | 
Pages: 1
Prev: Macro from cell specific to whole column
Next: Sumproduct - Return value as Blank