Macro to move between sheets

[Pete JM]

Hi,

I would like to have a macro that would look at a value in cell A5 and
then go to the Worksheet that has the same name.

For example if i typed Sheet 1 in cell A1 then clicked on the macro i
would automatically be taken to Sheet 1.

Is this possible?

Regards

Pete

 

[Don Guillett]

How about a fully automatic way. NO clicking necessary
Right click sheet tab>view code>insert this.
Now when you type sheet1 in cell a1 you will goto sheet1

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.address <> "$A$1" Then Exit Sub
Sheets(Target.Value).Select
End Sub

 

[Pete JM]

Thank you very much for your reply its very useful.

thanks again

Pet

 

[Don Guillett]

glad to help