Is there Formula to Tab to certain cells

E

Ev

Is there a formula to tab through certain cells? I have a form with about 15
cells that I would like to access easily through the tab key....is there any
way to do that?
 
R

RagDyer

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!
==============================================


Is there a formula to tab through certain cells? I have a form with about
15
cells that I would like to access easily through the tab key....is there any
way to do that?
 
P

prashant

yes there is a way.
1. select all the cell and hide and lock them from the
format?cell..>protection menu
2. then protec the sheet
3. then select the cells which u waht tabs to and again unhide and unlock them
4. now again protect the sheet
5, now tab
6. cursor will only move to the cells u unhide.
 
J

Jim May

The only little trick to this is say If you have a sequence of 15 cells, do
as follows:
Hold down the control key and start by Clicking your Number 2 choice FIRST,
and continue in sequence up to Number 15, then lastly click on Number 1;
With all selected, go to Insert, Names, Define, give-it--name (Test), and
OK - Your set..
From the Namebox select Test - and Your Number 1 cell becomes the
activecell;
Whether using Tab OR Enter will restrict the cursor to your 15 cells,
Good Luck
Jim May
 
D

David McRitchie

A formula can only receive a value, it cannot do anything else. You might
want to read Chip Pearson's
Macros And Functions (Functions as Opposed to Macros)
http://www.cpearson.com/excel/differen.htm

Worksheet protection, a selection range, or a named range,
have been mentioned so far.

I think for your situation of 15 cells the combination of protected and unprotected
cells would work best, and would require the least maintenance as it
should be automatic if you insert/delete cells or rows/columns.

Another possibility for some other situations might be an an Event macro.
Worksheet_SelectionChange to prevent entry past a column
http://www.mvps.org/dmcritchie/excel/event.htm#ws_sc
 
G

Gord Dibben

Ev

You have received a few answers to this.

The cell protection and TAB method works if your cell order is left to right,
top to bottom.

If random order, the named range will work best.

OR worksheet event code as David suggests.

Gord Dibben Excel MVP
 
Top