Move from cell A1 to R362 by selecting control tool or something
 

I've created a form that has ended up being 12 pages long.
I want to use a command button or object button or something so the user can
move from one section to another by selecting one of the button choices.
For example, I just completed the "demographic" section and the next section
is on "pets". I don't have pets so I want to select a button to move to a
section that applies to me (like the "residence type" section of the form),
which is three pages away.
Thanks in advance.

Move from cell A1 to R362 by selecting control tool or something
 

Why not just add hyperlinks. Then you do not need to get into any code or
such...
--
HTH...

Jim Thomlinson


"Sheila" wrote:

I've created a form that has ended up being 12 pages long.
I want to use a command button or object button or something so the user can
move from one section to another by selecting one of the button choices.
For example, I just completed the "demographic" section and the next section
is on "pets". I don't have pets so I want to select a button to move to a
section that applies to me (like the "residence type" section of the form),
which is three pages away.
Thanks in advance.

Move from cell A1 to R362 by selecting control tool or somethi
 

Humm. Ahh, don't know how to do one.
I read the help on the subject, but I was unable to create a hyperlink. It
sounds like it's what I need though.
Thanks.



"Jim Thomlinson" wrote:

Why not just add hyperlinks. Then you do not need to get into any code or
such...
--
HTH...

Jim Thomlinson


"Sheila" wrote:

I've created a form that has ended up being 12 pages long.
I want to use a command button or object button or something so the user can
move from one section to another by selecting one of the button choices.
For example, I just completed the "demographic" section and the next section
is on "pets". I don't have pets so I want to select a button to move to a
section that applies to me (like the "residence type" section of the form),
which is three pages away.
Thanks in advance.

Move from cell A1 to R362 by selecting control tool or something
 

Oh, yeah. Oh yeah. That did it! Exactly what I needed. Thank you, thank
you. You da man!

S





"Sheila" wrote:

I've created a form that has ended up being 12 pages long.
I want to use a command button or object button or something so the user can
move from one section to another by selecting one of the button choices.
For example, I just completed the "demographic" section and the next section
is on "pets". I don't have pets so I want to select a button to move to a
section that applies to me (like the "residence type" section of the form),
which is three pages away.
Thanks in advance.

Move from cell A1 to R362 by selecting control tool or somethi
 

I would not use Hyperlinks..........how do you get back to where you started
without another Hyperlink?

I would use Names.

Name the top cell of each section under InsertNameDefine.

Then just select one of those names from the NameBox left end of Formula Bar.

No Hyperlinks needed


Gord Dibben MS Excel MVP

On Thu, 20 Mar 2008 14:07:02 -0700, Sheila
wrote:

Humm. Ahh, don't know how to do one.
I read the help on the subject, but I was unable to create a hyperlink. It
sounds like it's what I need though.
Thanks.



"Jim Thomlinson" wrote:

Why not just add hyperlinks. Then you do not need to get into any code or
such...
--
HTH...

Jim Thomlinson


"Sheila" wrote:

I've created a form that has ended up being 12 pages long.
I want to use a command button or object button or something so the user can
move from one section to another by selecting one of the button choices.
For example, I just completed the "demographic" section and the next section
is on "pets". I don't have pets so I want to select a button to move to a
section that applies to me (like the "residence type" section of the form),
which is three pages away.
Thanks in advance.

Move from cell A1 to R362 by selecting control tool or somethi
 

Very interesting......
I will definitely give this a try and see how it works.
I appreciate having choices.
Thank you.

Sheila

"Gord Dibben" wrote:

I would not use Hyperlinks..........how do you get back to where you started
without another Hyperlink?

I would use Names.

Name the top cell of each section under InsertNameDefine.

Then just select one of those names from the NameBox left end of Formula Bar.

No Hyperlinks needed


Gord Dibben MS Excel MVP

On Thu, 20 Mar 2008 14:07:02 -0700, Sheila
wrote:

Humm. Ahh, don't know how to do one.
I read the help on the subject, but I was unable to create a hyperlink. It
sounds like it's what I need though.
Thanks.



"Jim Thomlinson" wrote:

Why not just add hyperlinks. Then you do not need to get into any code or
such...
--
HTH...

Jim Thomlinson


"Sheila" wrote:

I've created a form that has ended up being 12 pages long.
I want to use a command button or object button or something so the user can
move from one section to another by selecting one of the button choices.
For example, I just completed the "demographic" section and the next section
is on "pets". I don't have pets so I want to select a button to move to a
section that applies to me (like the "residence type" section of the form),
which is three pages away.
Thanks in advance.