Should be an easy one for you guys

I want to enter a string into a field/cell and when specified number of characters has been reached (in this case just the 1) I want Excel to automatically ENTER and tab to the next cell on the right without the user having to press ENTER or TAB.

Can someone educate the uneducated, please?

 

Use Access instead?

You can always export the data to excel for analysis

 

No - its for an automated-type-thing.... the user inputs the data directly.

Can it be done?

 

bump

 

Mate

You should be able to write a small macro to do this very easily. look up macros in the excel help theres a fair bit of info on this.

 

If it is only 1 character I assume it is either a - z or 0 -9 ?
If that is the case why not set up as a drop down selection box.

 

You might not be able to achieve this without creating a form as it doesn't look like Excel can react to keypress events on a worksheet.