Tab order help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have used the following information to create a tab oder in a form I have
created. I copied the code to the VBA and it is still not working correctly.
On my form I have 8 fields only that I have unlocked and only these 8 fields
do I want editting possible. Am I doing something wrong? Also I need to
share this with other users. Thank you Kasey


I have copied the code and it does not work still.
I do not even understand what the code is actually tyring to say there.

Can you give me a possible breakdown of what is going on?
 
The code is from Anne Troy and is sheet event code.

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")

'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

Code is placed into the sheet module by right-click on the sheet tab and "View
Code"

Paste into that module.


Gord Dibben MS Excel MVP

Please post your code and tell us exactly what you want to do.
Thanks,
Barb Reinhardt
Click to expand...
 
I looked at that code, but it would be useful to know if it's exactly the
same as what's there or a modification of it. It's also possible that the
code is not in the worksheet module, but in another module. Also, If the
changed cell address isn't in the array, it appears to go down to the next
cell.

Barb Reinhardt
 
True.

I guess we'll wait for OP to get back with the exact code used and where it is
stored.


Thanks, Gord

I looked at that code, but it would be useful to know if it's exactly the
same as what's there or a modification of it. It's also possible that the
code is not in the worksheet module, but in another module. Also, If the
changed cell address isn't in the array, it appears to go down to the next
cell.

Barb Reinhardt
Click to expand...
 
Back
Top