Can I automatically tab to next cell?

  • Thread starter Thread starter Patrick McKann
  • Start date Start date
P

Patrick McKann

I want to be able to enter just one character (c, o, or d
for example) in a cell, then have the program accept it
and automatically tab me to the next tab in the row. Is
this possible??? PLease help if you can.
 
Patrick

If you don't leave the cell Excel doesn't know you are finished with your data
entry.

You can TAB out, ENTER out or ARROW out, but you must leave the cell.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
To do this would require an event macro, but no macros run while you are in "edit mode".

Once you press F2 or enter a character in a cell to start Edit mode, you remain in that mode
until you "tell" Excel you are finished -- by pressing Enter, Tab, an arrow key, etc. No macro
can run until you press such a key. So in effect the answer to your question is "no".
 
Back
Top