Tab Key Control?

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

Guest

Is there a way to control the response from the tab key? (i.e.--skip over cells that are not dependent on user input

Any help would be greatly appreciated

Don
 
Hi Jaso

Have done this, but the tab key function still hits those cells. They are protected from input, but what I'm trying to do is have the tab key jump to the next cell that requires user input. I've done this on another program, long ago, but can't seem to find it on Excel

Thanks for the response anyway

Don
 
When using the "protect worksheet - lock cell" procedure to control focus
movement, *that* movement is restricted to following the normal <tab> route,
which is left to right.

One way to explicitly control the exact "next cell of focus" selection, is
to select the cells in the desired order of travel, and then preserve this
ordered movement by creating a named range.

This old post describes the steps that can be taken to create such a "named
range".

http://tinyurl.com/39vzv


--

HTH,

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

Hi Jason

Have done this, but the tab key function still hits those cells. They are
protected from input, but what I'm trying to do is have the tab key jump to
the next cell that requires user input. I've done this on another program,
long ago, but can't seem to find it on Excel.

Thanks for the response anyway,

Don
 
Sorry, I think I jumbled my words. By default, all cells
are locked. So hold down the Ctrl key and select all cells
that *require* user input. Then unlock those cells. Now
protect the sheet. You should only be able to tab to the
unlocked cells.

Jason
-----Original Message-----
Hi Jason

Have done this, but the tab key function still hits those
Click to expand...
cells. They are protected from input, but what I'm trying
to do is have the tab key jump to the next cell that
requires user input. I've done this on another program,
long ago, but can't seem to find it on Excel.
 
Don

To TAB to desired cells.......

1. Unlock the cells you want to TAB to then protect the worksheet.

If your unlocked cells are in a left to right, top to bottom series, the TAB
key will move you through them as long as Sheet Protection is enabled.

2. If not in this configuration.....you can do it with a Named Range and no
sheet protection.

Assuming your range of cells to be A1, B2, C3, F4, A2, F1 for example.

Select the Second cell(B2) you want in the range then CRTL + click your way
through the range in the order you wish, ending with the First cell(A1). Name
this range under Insert>Name>Define>OK.

Now click on NameBox(top left corner above row 1 and col A), select the range
name to highlight the range. With these cells selected, you can input data
and Tab or Enter your way through the range in the order you selected.

Note: there is a limit of about 25 - 30 cells to a range using this method due
to a 255 character limit in a named range. Longer sheet names will reduce the
number of cells considerably.

If more needed, you can enter them manually in thr "refers to" box.

From Debra Dalgleish.....
The limit is 255 characters in the Name definition. For example, I can
define a range of 46 non-contiguous cells, with the following string:

=$B$2,$D$2,$F$2,$H$2,$J$2,$B$4,$D$4,$F$4,$H$4,$J$4,$B$6,$D$6,$F$6,$H$6,
$J$6,$B$8,$D$8,$F$8,$H$8,$J$8,$B$10,$D$10,$F$10,$H$10,$J$10,$B$12,$D$12,
$F$12,$H$12,$J$12,$B$14,$D$14,$F$14,$H$14,$J$14,$B$16,$D$16,$F$16,$H$16,
$J$16,$B$18,$D$18,$F$18,$H$18,$J$18,$L$3
Click to expand...

There is a third method which requires VBA and a Worksheet_Change event.

''moves from C2 through E5 at entry
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

Gord Dibben Excel MVP
 
Back
Top