Rather than creating a complex form with all the associated VBA
coding I have created a worksheet which will transfer information to
another sheet - using one macro

The input worksheet has input boxes all over the place and I was
wondering if it is at all possible to tab or use enter to jump from
cells A1 to C4 to D16 etc etc. similar to the way that a created form
works

Any help would be appreciated

Thanks

Brian

A simple way without using VBA would be to protect all the cells in the
worksheet from being selected expect the input cells. Then a tab would go
from one input cell to the next.

With VBA, an event macro could direct the transitions.
--
Gary''s Student - gsnu201001


"BJ&theBear" wrote:

Rather than creating a complex form with all the associated VBA
coding I have created a worksheet which will transfer information to
another sheet - using one macro

The input worksheet has input boxes all over the place and I was
wondering if it is at all possible to tab or use enter to jump from
cells A1 to C4 to D16 etc etc. similar to the way that a created form
works

Any help would be appreciated

Thanks

Brian

.

If your input cells are in aleft to right, top to bottom sequence, unlocking
input cells and Tabbing to them will work.

If not in that sequence you can create a named range in the order you want.

Start with last cell in order then CTRL + Click your way through the
sequence.

See Bob Phillips' site for more on this.

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


Gord Dibben MS Excel MVP

On Sun, 4 Apr 2010 05:03:33 -0700 (PDT), "BJ&theBear"
wrote:

Rather than creating a complex form with all the associated VBA
coding I have created a worksheet which will transfer information to
another sheet - using one macro

The input worksheet has input boxes all over the place and I was
wondering if it is at all possible to tab or use enter to jump from
cells A1 to C4 to D16 etc etc. similar to the way that a created form
works

Any help would be appreciated

Thanks

Brian