Tab from a Validated Cell to another
 

I need to tab from one validated cell to another

Tab from a Validated Cell to another
 

You could name the cells and call the named range from the Name Box drop
down.

Select the SECOND cell and hold down CTRL and select the remaining cells
ending with the FIRST cell you want. While still selected, click in the
name box and name the range. Now from the name box drop down you can select
the named range and Tab or Enter will advance you to the next cell in the
order you selected prior to naming.

If you have more than about 20 to 25 cells, you may have to use more than
one named range. Seems to bog down around that many cell or there about.

HTH
Regards,
Howard


"shad" wrote in message
...
I need to tab from one validated cell to another

Tab from a Validated Cell to another
 

L. Howard Kittle, Thanks for your help but I'm not sure what you are talking
about, can you give step by step instructions

"L. Howard Kittle" wrote:

You could name the cells and call the named range from the Name Box drop
down.

Select the SECOND cell and hold down CTRL and select the remaining cells
ending with the FIRST cell you want. While still selected, click in the
name box and name the range. Now from the name box drop down you can select
the named range and Tab or Enter will advance you to the next cell in the
order you selected prior to naming.

If you have more than about 20 to 25 cells, you may have to use more than
one named range. Seems to bog down around that many cell or there about.

HTH
Regards,
Howard


"shad" wrote in message
...
I need to tab from one validated cell to another

Tab from a Validated Cell to another
 

Sure. Lets say the validation cells are A1, B2, C3, D4, E5, F6 and you want
to move through them in just that order.

Select B2 and hold down the CTRL key and with the CTRL key held down select
the other cells, C3 then D4 then E5 then F6 and last A1. Now release the
CTRL key and while all the cells are still selected, click in the Name Box,
which is just above the A column. It will have A1 in it. When you click in
the box it will highlight A1 and move it to the left. Just type in a name,
i.e. MyValCells. Hit Enter.

To use, notice the small down arrow just to the right of the Name Box.
Click it and the Name Box will display all named ranges on the sheet. You
should see MyValCells, just click on it and the range on the sheet will be
highlighted, with A1 as the current selection. Make your data validation
choice for A1 and use either Enter or Tab to move to the next cell. Do the
same with each cell. When done click elsewhere on the sheet to remove the
highlighting.

HTH
Regards,
Howard

"shad" wrote in message
...
L. Howard Kittle, Thanks for your help but I'm not sure what you are
talking
about, can you give step by step instructions

"L. Howard Kittle" wrote:

You could name the cells and call the named range from the Name Box drop
down.

Select the SECOND cell and hold down CTRL and select the remaining cells
ending with the FIRST cell you want. While still selected, click in the
name box and name the range. Now from the name box drop down you can
select
the named range and Tab or Enter will advance you to the next cell in the
order you selected prior to naming.

If you have more than about 20 to 25 cells, you may have to use more than
one named range. Seems to bog down around that many cell or there about.

HTH
Regards,
Howard


"shad" wrote in message
...
I need to tab from one validated cell to another

Tab from a Validated Cell to another
 

In addition to the info Howard has provided.

You are limited to 255 characters in the "refers to" dialog.

Excel places the sheet name with each cell you click on so this reduces the
number of cells you can choose.

There is a way around this.................

See Bob Phillips' site for getting about 45 cells.

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

Note the use of the F4 key to turn the cells to Absolute after you have typed
them into the dialog box as a1,b2,c3,d4 etc.


Gord Dibben MS Excel MVP


On Sun, 4 Feb 2007 12:03:59 -0800, "L. Howard Kittle"
wrote:

Sure. Lets say the validation cells are A1, B2, C3, D4, E5, F6 and you want
to move through them in just that order.

Select B2 and hold down the CTRL key and with the CTRL key held down select
the other cells, C3 then D4 then E5 then F6 and last A1. Now release the
CTRL key and while all the cells are still selected, click in the Name Box,
which is just above the A column. It will have A1 in it. When you click in
the box it will highlight A1 and move it to the left. Just type in a name,
i.e. MyValCells. Hit Enter.

To use, notice the small down arrow just to the right of the Name Box.
Click it and the Name Box will display all named ranges on the sheet. You
should see MyValCells, just click on it and the range on the sheet will be
highlighted, with A1 as the current selection. Make your data validation
choice for A1 and use either Enter or Tab to move to the next cell. Do the
same with each cell. When done click elsewhere on the sheet to remove the
highlighting.

HTH
Regards,
Howard

"shad" wrote in message
...
L. Howard Kittle, Thanks for your help but I'm not sure what you are
talking
about, can you give step by step instructions

"L. Howard Kittle" wrote:

You could name the cells and call the named range from the Name Box drop
down.

Select the SECOND cell and hold down CTRL and select the remaining cells
ending with the FIRST cell you want. While still selected, click in the
name box and name the range. Now from the name box drop down you can
select
the named range and Tab or Enter will advance you to the next cell in the
order you selected prior to naming.

If you have more than about 20 to 25 cells, you may have to use more than
one named range. Seems to bog down around that many cell or there about.

HTH
Regards,
Howard


"shad" wrote in message
...
I need to tab from one validated cell to another