| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button to take the user in a different place on the same sheet
Hello,
I have a command button (Button 4585). I would like it to take the user to another place (cells A147:A180) on the same sheet (Sheet 10). Is this possible? I cannot just use a hyperlink on a cell as the button only becomes visible if the user makes certain choices. Thanks very much in advance. Johanna |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Button to take the user in a different place on the same sheet
Try attaching this macro
Sub Button4585_Click() Sheets("Sheet10").Activate 'Range("A147").Select 'this will go to A147 Range("A147:A180").Select 'this will HIGHLIGHT range End Sub Choose one of the Range() lines only remove ' from Range("A147").select if want to use that Jason "Johanna Gronlund" wrote: Hello, I have a command button (Button 4585). I would like it to take the user to another place (cells A147:A180) on the same sheet (Sheet 10). Is this possible? I cannot just use a hyperlink on a cell as the button only becomes visible if the user makes certain choices. Thanks very much in advance. Johanna |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Button to take the user in a different place on the same sheet
Also in your case use
Sheets("Sheet 10").Activate and not Sheet10 as your sheet name has a space. Jason "Jason Falzon" wrote: Try attaching this macro Sub Button4585_Click() Sheets("Sheet10").Activate 'Range("A147").Select 'this will go to A147 Range("A147:A180").Select 'this will HIGHLIGHT range End Sub Choose one of the Range() lines only remove ' from Range("A147").select if want to use that Jason "Johanna Gronlund" wrote: Hello, I have a command button (Button 4585). I would like it to take the user to another place (cells A147:A180) on the same sheet (Sheet 10). Is this possible? I cannot just use a hyperlink on a cell as the button only becomes visible if the user makes certain choices. Thanks very much in advance. Johanna |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Button to take the user in a different place on the same sheet
Thanks, this was very useful and worked.
Johanna "Jason Falzon" wrote: Also in your case use Sheets("Sheet 10").Activate and not Sheet10 as your sheet name has a space. Jason "Jason Falzon" wrote: Try attaching this macro Sub Button4585_Click() Sheets("Sheet10").Activate 'Range("A147").Select 'this will go to A147 Range("A147:A180").Select 'this will HIGHLIGHT range End Sub Choose one of the Range() lines only remove ' from Range("A147").select if want to use that Jason "Johanna Gronlund" wrote: Hello, I have a command button (Button 4585). I would like it to take the user to another place (cells A147:A180) on the same sheet (Sheet 10). Is this possible? I cannot just use a hyperlink on a cell as the button only becomes visible if the user makes certain choices. Thanks very much in advance. Johanna |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Button to take the user in a different place on the same sheet
First give the range a name.
InsertNameDefine myrng Private Sub CommandButton1_Click() Application.Goto Reference:="myrng" End Sub Gord Dibben MS Excel MVP On Thu, 1 Apr 2010 00:41:01 -0700, Johanna Gronlund wrote: Hello, I have a command button (Button 4585). I would like it to take the user to another place (cells A147:A180) on the same sheet (Sheet 10). Is this possible? I cannot just use a hyperlink on a cell as the button only becomes visible if the user makes certain choices. Thanks very much in advance. Johanna |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a "Next" button to move the user to the next sheet | Excel Discussion (Misc queries) | |||
| To Place Button in Excel | Excel Programming | |||
| Place a User Form on Start Up | Excel Programming | |||
| command button to move user to specific spot on different sheet | Excel Programming | |||
| How do I create a macro button and place anywhere on my sheet? | Excel Discussion (Misc queries) | |||
Linear Mode
