S
shad
I need to tab from one validated cell to another
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
L. Howard Kittle
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
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
S
shad
L. Howard Kittle, Thanks for your help but I'm not sure what you are talking
about, can you give step by step instructions
about, can you give step by step instructions
L
L. Howard Kittle
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
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
G
Gord Dibben
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
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