Private Sub b_ok_Click()
'ligne = Me.ListBox1.ListIndex + 2
'temp = Sheets("BD").Cells(ligne, "c").Hyperlinks(1).SubAddress
Set c = Sheets("BD").Columns(3).Find(Me.ListBox3, LookIn:=xlValues, lookat:=xlWhole)
If Not c Is Nothing Then
temp = c.Hyperlinks(1).SubAddress
End If
a = Split(temp, "!")
Application.Goto Reference:=Worksheets(a(0)).Range(a(1))
Unload UserForm1
End Sub