Button to take the user in a different place on the same sheet

[Johanna Gronlund]

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

 

[Jason Falzon]

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

 

[Jason Falzon]

Also in your case use


Sheets("Sheet 10").Activate

and not Sheet10 as your sheet name has a space.


Jason

 

[Johanna Gronlund]

Thanks, this was very useful and worked.

Johanna

 

[Gord Dibben]

First give the range a name.

Insert>Name>Define myrng

Private Sub CommandButton1_Click()
Application.Goto Reference:="myrng"
End Sub


Gord Dibben MS Excel MVP