Moving between cells when enter is pressed

[woalmoore]

I am creating a user form.
I want to specify which cells are accessed when enter is pressed. I know
how to specify whether the cells move down or to the right when enter is
presed but sometimes I need it to move to the right and other times I need it
to move down and to the left-most square that it unlocked. However, when it
is used on a different computer, the default setup on that computer is used.
Is there a way to program cells to move in a certain progression and save
that progression with the file? (ala the way you can program a style
progression in word) Thanks.

 

[Jim Thomlinson]

The short answer is no...

 

[John C]

Best choice is to have a separate tab (such as Input), with a row
representing a single record, and the columns in your desired order, then
having your appropriately formatted tab (such as Main) refer back to the
Input tab.

 

[Gord Dibben]

See Bob Phillips' site for a couple of methods to set the Tab order.

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

Note: if you go with the named range method, just enter the cells in the Refers
to: dialog as A1, A2, G4, H1 etc. then highlight all and hit F4 to add the $
signs.

There is also a VBA method using sheet event code if you want it.

Post back if so.


Gord Dibben MS Excel MVP