| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I move Excel 2007 tool bars to the bottom of screen or get rid | Excel Discussion (Misc queries) | |||
| CONTROL TOOL BOXXXX!! HELP! SOS!! | Excel Discussion (Misc queries) | |||
| Control Tool Box | New Users to Excel | |||
| Selecting every other row to delete or move | Excel Discussion (Misc queries) | |||
| control-tab should move between Excel sheets without a mouse. | Excel Worksheet Functions | |||
Hybrid Mode
