Automatically moving to next cell after entering a digit

[michaeltmaguire]

Is there any way to make Excel automatically move down to the next cell after entering a single digit. What I'm hoping to be able to do is enter a number in a cell (in most cases, it's just "0" or "1") and then have Excel automatically move to the next cell down WITHOUT hitting enter.

Thanks!

Mike

[Blake 7]

As far as i'm aware this cannot be done.

Data isn't updated until pressing enter or tab, so the worksheet_change event won't work either.

You could use a DV List --- ?

[michaeltmaguire]

Oh well. Thanks Blake 7.