CELL ORDER

[tarheelrooster]

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.

 

[Gord Dibben]

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