Worksheets("Feuil2").Cells(i, 1).Hyperlinks.Items(1).Follow
Private Sub ListBox1_Click() Dim i As Integer i = 2 Worksheets("Feuil2").Select Do While Cells(i, 13) <> "" If Cells(i, 13).Text = UserForm1.ListBox1.List(i) Then Worksheets("Feuil2").Cells(i, 13).Hyperlink.Follow NewWindow:=True Exit Sub End If i = i + 1 Loop End Sub
UserForm1.ListBox1.Clear Dim aCC(0 To 2000, 0 To 50) For m = 1 To Sheets("Feuil2").Range("A65536").End(xlUp).Row If Not Sheets("Feuil2").Rows(m + 1).Hidden Then For t = 0 To Colonne + 1 aCC(m, t) = Sheets("Feuil2").Cells(m + 1, t + 1) Next t End If Next m UserForm1.ListBox1.Clear UserForm1.ListBox1.ColumnCount = Colonne UserForm1.ListBox1.BoundColumn = 13 UserForm1.ListBox1.ColumnWidths = "20;20;20;20;25;150;150;150;50;50;50;50;50" UserForm1.ListBox1.List() = aCC UserForm1.Show
Private Sub ListBox1_Click() Dim Lien As String Lien = UserForm1.ListBox1.Text Dim i As Integer i = 2 Worksheets("Feuil2").Select Do While Cells(i, 13) <> "" If Cells(i, 13).Value = Lien Then Worksheets("Feuil2").Cells(i, 13).Hyperlinks.Item(13).Address Exit Sub End If i = i + 1 Loop End Sub
Dim I as integer For i = 2 to 2000 Userform1.listbox1.list(i).Hyperlink.Address = Worksheet(?Feuil2?).Cells(i, 13).Hyperlink.Address Next
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question