CELL ORDER
 

I have created a form and want to have a specific cell highlighted each time
I hit the enter key. Can I choose the order of the cells? How? Excel 2000.
i/e IF I start with A1 and hit enter I want G5 to highlight and hit enter
and then maybe L9.

CELL ORDER
 

Couple of methods.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

You may instead want to use VBA code to step through cells in order.

Post back if that appeals.


Gord Dibben MS Excel MVP

On Thu, 1 Oct 2009 09:26:01 -0700, tarheelrooster
wrote:

I have created a form and want to have a specific cell highlighted each time
I hit the enter key. Can I choose the order of the cells? How? Excel 2000.
i/e IF I start with A1 and hit enter I want G5 to highlight and hit enter
and then maybe L9.