Tabbing through input worksheet
 

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

Tabbing through input worksheet
 

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

.

Tabbing through input worksheet
 

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