Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Count > 1 Then Exit Sub
If Target <> "" Then
If Not Sheets("sheet2").Cells.Find(Target.Value, lookat:=xlWhole) Is Nothing Then
Sheets(2).Select
Sheets("sheet2").Cells.Find(Target.Value, lookat:=xlWhole).Select
End If
End If
End Sub
温馨提示:答案为网友推荐,仅供参考