How do i setup tabbing order of cells?

[stephen]

I am trying to set up a worksheet with a certain tabbing order I want to it
to going from F4 to H5 to B6 to F7 to P7 to H8 to P8 then to AB4 to AH3 to
F11 to AO10... Just wondering how to do this in Microsoft excel 2007. I
already have them unlocked, and protected, but cannot get it to tab in that
order.

 

[Harald Staff]

It is possible, but awfully complicated and pretty vulnerable. Try to design
your user interface in another way.

Best wishes Harald

 

[Jim Thomlinson]

Unless you enjoy writing and maintaining custom macros then you need to
rethink your interface. Additionally from my experience end users find it ver
disconcerting if the active cell is mover around to here there and everywhere
each time they enter an item.

Have you considered a data entry page where you ask for all of the pertient
information and once they have entered the info, then take them to the next
page where it shows all of the info filled in. Similar to all of the tax
software that has you fill in all of your information in one spot and then
adds that info to your tax forms.

 

[Jim Thomlinson]

Wow... even for me that is bad typing...

Unless you enjoy writing and maintaining custom macros then you need to
rethink your interface. Additionally from my experience end users find it
very
disconcerting if the active cell is moving around to here there and
everywhere
each time they enter an item.

Have you considered a data entry page where you ask for all of the pertinent
information and once they have entered the info, then take them to the next
page where it shows all of the info filled in. Similar to all of the tax
software that has you fill in all of your information in one spot and then
adds that info to your tax forms.

 

[RagDyer]

See if this old post helps:

http://tinyurl.com/3kksgy

 

[stephen]

What i am trying to do is setup a form that can be filled out. There is a
top section, and then a left and right section all on the same page, yet i
dont want it to tab over into the right section until all of the left is
complete. That is why i want to name the cells in order, but i have over 146
cells to fill in. So i am lost on what to do, because it needs to be
protected, yet tab correctly. Anyother software that might work better if
excel cannot?

 

[Gord Dibben]

If you don't mind disconcerting your users or maintaining code here is an
example of tabbing order event code from Anne Troy.

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", "B5", "C5", "A10", "B10", "C10") '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

 

[RagDyeR]

See if you can work with something like this:

http://www.contextures.com/xlUserForm01.html


--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------


What i am trying to do is setup a form that can be filled out. There is a
top section, and then a left and right section all on the same page, yet i
dont want it to tab over into the right section until all of the left is
complete. That is why i want to name the cells in order, but i have over 146
cells to fill in. So i am lost on what to do, because it needs to be
protected, yet tab correctly. Anyother software that might work better if
excel cannot?

 

[Harald Staff]

User interface design is said to be a combination of art and science. Can it
be that there are 146 mandatory fields to be correctly filled out for each
single entry ? This is overwhelming for any user, tab order fixed or not, it
is not a platform question. See if one entry can inherit something from the
previous, if something can be a qualified guess by the form, if it van be
enterede in parts, ...

HTH. Best wishes Harald