software

Hello:
I have searched this forum for an answer, and found some really nice replies
to a variety of problems, so I decided to see if someone here could help me.
I have a form that I have to type serial numbers into separate boxes.
Currently, I have each character being put into a single cell, but it's very
tedious having to hit tab, enter or an arrow key after each number or letter
to move to the next cell.
Does anyone have a suggestion for being able to just type the serial number
and have each digit go in the next box automatically? If you'd like to see
the form, I've posted it he www.tjrvsales.com/BLANK_ MONTHL_
DMV_REPORT.xlt
Any help would be greatly appreciated!

Excel has no way of knowing if you are finished with data entry in a cell unless
you give it some help.

This help can be using the enter key, tab key or an arrow key.

In short, there MUST be a trigger Excel recognizes.Gord Dibben MS Excel MVP

On Mon, 13 Mar 2006 22:20:55 GMT, quot;KPSEquot; lt;u19650@uwegt; wrote:

gt;Hello:
gt;I have searched this forum for an answer, and found some really nice replies
gt;to a variety of problems, so I decided to see if someone here could help me.
gt;I have a form that I have to type serial numbers into separate boxes.
gt;Currently, I have each character being put into a single cell, but it's very
gt;tedious having to hit tab, enter or an arrow key after each number or letter
gt;to move to the next cell.
gt;Does anyone have a suggestion for being able to just type the serial number
gt;and have each digit go in the next box automatically? If you'd like to see
gt;the form, I've posted it he www.tjrvsales.com BLANK_MONTHL_DMV_REPORT.xlt
gt;Any help would be greatly appreciated!Would there be a way of writing an IF statement or macro that would verify 1
character typed then move to the next cell?

Gord Dibben wrote:
gt;Excel has no way of knowing if you are finished with data entry in a cell unless
gt;you give it some help.
gt;
gt;This help can be using the enter key, tab key or an arrow key.
gt;
gt;In short, there MUST be a trigger Excel recognizes.
gt;
gt;Gord Dibben MS Excel MVP
gt;
gt;gt;Hello:
gt;gt;I have searched this forum for an answer, and found some really nice replies
gt;[quoted text clipped - 7 lines]
gt;gt;the form, I've posted it he www.tjrvsales.com BLANK_MONTHL_DMV_REPORT.xlt
gt;gt;Any help would be greatly appreciated!