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.

The short answer is no...
--
HTH...

Jim Thomlinson


"woalmoore" wrote:

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.

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.
--
John C


"woalmoore" wrote:

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.

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

On Fri, 18 Jul 2008 07:32:09 -0700, woalmoore
wrote:

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.