I know its not access, but...(tab order)

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

Guest

Can you change the tab order in a worksheet? I have a checklist I have
compiled in a worksheet and with most cells locked, but have unlocked all
cells which need input. The tab order is of course left to right, is there
any way to customize this (much like you can in Access)?
 
if you are talking about the tab that usually says "sheet1", "sheet 2", etc.
then yes you can i fyou have excel 2003, simply by right clicking the tab and
going to tab color
 
You cannot change the Tab order of unlocked cells in a sheet.

Left to right and top to bottom is the order.

You can use other methods to give a Tab order of your choosing.

See Bob Phillips' site for help on the "named range" method.

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

You can also use VBA event code to set an order.

Post back if you want an example of that.


Gord Dibben MS Excel MVP
 
I am actually reading up on Macros (VBA) right now. I have never ventured
that far into Excel, so this is brand new territory for me. I read a couple
of other posts that say you can set up a macro to run your preferred tab
order. If you have any help or if you think your example may help me get
started, I would love the help. If not, wish me luck ~ I think I have a lot
of reading to do! Thanks to all for the replies.
 
Here is the example.

''moves from C2 through E5 at entry of data
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$C$2"
Range("C5").Select
Case "$C$5"
Range("E2").Select
Case "$E$2"
Range("E5").Select
End Select
End Sub

This worksheet event code.

Right-click on the sheet tab and "View Code"

Copy/paste the code into that sheet module..

Adjust the cell refs and add more Cases as you need.

NOTE: the ENTER key can be used as well as the Tab key.


Gord

I am actually reading up on Macros (VBA) right now. I have never ventured
that far into Excel, so this is brand new territory for me. I read a couple
of other posts that say you can set up a macro to run your preferred tab
order. If you have any help or if you think your example may help me get
started, I would love the help. If not, wish me luck ~ I think I have a lot
of reading to do! Thanks to all for the replies.
Click to expand...

Gord Dibben MS Excel MVP
 
Back
Top