How can you open a tab(Sheet5) by clicking on particular cell say.

[Suren Suthar]

I made index on sheet 1. If my cell a2 has text INFO and my shhet 5 has the
details of INFO, what do I need to program so when I click on A2, it opens up
sheet 5 as soon as the clicking is done? Also as an alternate, I can store
iINFO details starting on cell b62. Can you go to b62 by clicking on a2?

[Chip]

So want when someone clicks on cell A2, that it will take the user to
Sheet5 Cell B62?

[Suren Suthar]

"Chip" wrote:

> So want when someone clicks on cell A2, that it will take the user to
> Sheet5 Cell B62?
>
> Actually sheet 5 cell a1 or shhet 1, cell b62

[Casper]

1. To activate specific sheet by clicking on cell put this code in sheet where is cell to click


Private Sub Worksheet_SelectionChange(ByVal Target As Range)


If Target.Column = 1 And Target.Row = 1 Then 'observed cell is (1,1) - A1

Worksheets("sheet2").Activate 'sheet2 is name of sheet that will be activated

End If

End Sub

2. to select specific cell by clicking on some cell (in same sheet) put this code in sheet

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Target.Column = 1 And Target.Row = 1 Then 'observed cell is (1,1) - A1

Cells(4, 8).Select 'target cell is (4,8) - H8

End If

End Sub

[plcarr@gmail.com]

Instead of writing code it would be easier to insert a hyperlink to the
required location