tab direction

[IC]

I'm sure it's been asked (and answered) a hunderd times before but, is it
possible to change the tab direction so that instead of the tab key moving
to the next unlocked cell to the right, it moves to the next unlocked cell
down?

Many thanks in advance for any and all input.

Ian

 

[Tom Ogilvy]

There is no setting that I am aware of that would alter this.

 

[Don Lloyd]

Ian,
This changes the direction after pressing the ENTER key,

Application.MoveAfterReturn = True
Application.MoveAfterReturnDirection = xlDown (ToRight, ToLeft, Up)

Regards,
Don

 

[Tom Ogilvy]

The question was for the tab key, which those settings do not affect.

 

[Peter Huang]

Hi Lan,

Based on my knowledge, we can not change the default behavior of the TAB
key.
Why do you want to do this, if you have any concern, please feel free to
post here.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[IC]

Unfortunately ENTER does not restrict movement to unlocked cells.

 

[IC]

Is there a way to tab from one cell to one other specific cell? I need to
tab from B5 to F10 but G9:I9 are unlocked.

Ideally, I need to tab down a specific column (F, G, H or I) but cells are
unlocked in all these columns. I suspect this isn't possible.

I tried using a named range, but rows 12 and below contain code which is
activated on selection and the range selects the cells first.

Ian

 

[Peter Huang]

Hi,

I think it is hard to do that, because how can we tell that when we press
Tab how many cells should be skipped.
I think for your scenario, we can try to wrtie a if..endif statement to
judge if we need to fire some event when we use tab to navigate through the
cells on the sheet.
If you still have any concern, please feel free to post here.


Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Tom Ogilvy]

If you have a specific set of cells you want to tab through in a specific
order, you can select the cells using the ctrl key in the order in which you
want to tab through them. Then, go to the namebox and enter a name for the
range, sub as TabList

Now as long as the cells are selected, if you just hit the tab key, it will
follow that path. If you want to repeat this at a later time, go to the
name box, click the down arrow and select Tablist. then the cells will be
reselected with the previously established order.

 

[IC]

FYI, I solved the problem by using complex "If" statements in
Worksheet_Change to lock and unlaock cells as required.

Thanks for the pointer.

Ian