auto tab when cell is full

  • Thread starter Thread starter univarhb
  • Start date Start date
U

univarhb

Does anyone know of a quick and easy way to automatically advance to th
next cell when the maximum number of characters is reached in the cell?
I want to eliminate the need to press the tab or enter keys to speed u
the input of data
 
univarhb said:
Does anyone know of a quick and easy way to automatically advance to the
next cell when the maximum number of characters is reached in the cell?
I want to eliminate the need to press the tab or enter keys to speed up
the input of data.
Click to expand...

No, but remember that the limit is 32767 characters per cell (in Excel
2003).
 
Excel has no way of knowing when a certain number of characters has been entered
in a cell until you indicate in some manner that this is so.

i.e. hit enter, tab or arrow key to leave the cell

So...............no, there is no method to eliminate the need to press a key.


Gord Dibben MS Excel MVP
 
You could build a userform that counts the characters and when the limit is
reached, it could go to the next cell (whatever that means).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AUTO TAB BETWEEN CELLS 4
tab in a cell 3
make cell contain only 1 letter/number then tab automatically 3
worksheet sliding when cell is tabbed 2
Using Tab key to jump to specific cell 2
When pressing the tab key, 2
Cell advance i.e. tab 1
How do I limit a cell to one digit and have it automatically tab? 5

Back
Top