Simplified Data Entry?

[fastdan]

OK. Here's what I'd like to do. 1) Have a particular set of cells
only allow 2 digit numeric data. 2) After the 2nd digit is entered
auto-magically tab to the next field in the "table" without hitting th
Tab or Enter keys.

So, you might enter:

011653148902

And your results would be:

A B C
1 01 16 53
2 14 89 02


Make sense? Any assistance would be greatly appreciated

 

[Earl Kiosterud]

Dan,

You have some heads-down data entry going on here! I don't think this can
be done with data that's being entered into cells. Macros do not have any
control while the user is typing (Excel is in Enter or Edit mode).

You could do it with text boxes in a a Userform. This requires macros. The
Userform could be set up to do perhaps one row at a time, entering the data
into the sheet as you go either cell by cell, or at the end of a row.

 

[fastdan]

Thanks, Earl. I'll look in to that. :