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

[Sheila]

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.

 

[Jim Thomlinson]

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

 

[Sheila]

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.

 

[Sheila]

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

S

 

[Gord Dibben]

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 Insert>Name>Define.

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

No Hyperlinks needed


Gord Dibben MS Excel MVP

 

[Sheila]

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

Sheila