double click on a cell to redirect

[annazoubova]

Have a minor question here. How so I assign a macro to a "double click" event?

the idea is that I have a list of names on one worksheet and the same names on the other worksheet within the workbook. Shen I double-click on the original list, the excel redirects me to the same ne in the second worksheet.

Does anyone have any ideas?

Thanks for thinking
A

[RobDog888]

You can use either of these events depending on the passed parameters that you may need.

'Behind ThisWorkBook
Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
 
End Sub
 
'Behind a Sheet
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    
End Sub