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

.