View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
L. Howard Kittle L. Howard Kittle is offline
external usenet poster
 
Posts: 698
Default JUMP to the next cell with TAB key !

Hi Edgar,

Try this. Select all the cells that you need to enter info into starting
with the SECOND cell and holding down CTRL as you select and select the
FIRST cell last.

With the cells still selected, click in the Name Box and name that selection
of cell, (perhaps a name pertinent to the info that is to be entered) now
hit Enter. To begin entering your data, click on the drop down arrow at the
name box and select the name. All the cells will be highlighted and the
number 1 cell will be the edit cell (white while all the rest are blue).
Enter the 1st cell data and either hit Enter or Tab. Enter the next cell
data and continue. To get out of the named range loop, hit Home or click
anywhere on the sheet or select the next named range

You may have several cells in the named range and be aware there seems to be
a limit of about 20 to 30 for each named range. If that's a problem just
add another named range and name it pertinent to the info to entered in that
group of cells.

HTH
Regards,
Howard

"Edgar" wrote in message
...
I want to use the TAB key everytime I want to jump to the next cell.
Does anybody know how to do this? My form is a fill in form so I
want to hit the TAB key to go to the next one. I have having to use
my mouse to move to the next cell. Let me know, thank You.
--
Computer Tech