Prev: Using Picasso Photo Viewer to Open Excel Hyperlink in MS 2007?
Next: Calculation of Credit Card %
From: BJ&theBear on 4 Apr 2010 08:03
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

From: Gary''s Student on 4 Apr 2010 11:02
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
>
> .
>
From: Gord Dibben on 6 Apr 2010 11:48
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"
<brian.jermain(a)googlemail.com> 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

 | 
Pages: 1
Prev: Using Picasso Photo Viewer to Open Excel Hyperlink in MS 2007?
Next: Calculation of Credit Card %