Fill in 3 digits then cursor auto moves to next cell ( for phone# input )

[CKD777]

Hi, I need the formula to make filling in a users phone number easy. They would type in their first three numbers ( Area Code), the cursor would then automatically move to the next cell to the right (without having to push enter) The new cell would allow them to put in 3 more numbers, then moves to the next cell for the last 4 numbers, then to the next cell for a possible 5 digit extension.
Thank U!!

[davesexcel]

One possible solution would be to use data validation to select the area code, once a selection has been made, the cell next to it will be selected.

Check out the attached example.

Right click on the sheet tab and select View Code to see the code