Listbox doubleclick to followhyperlink

23 Views Asked by At

I have a listbox named Tableau in which I have 6 columns. I wrote a function that is supposed to send me to the web hyperlink when I click the request number (colunm 3 value), it opens the hyperlink that I gave to it.

I want it to add the request number that is located in the colunm 3 of the listbox to the end of the link to complete the web adress.
(ex: "www.google.com" & request_id from listbox)

I wrote the following but nothing seems to happen when I click the number from colunm 2

Dbclick code for listbox:

Private Sub tableau_DbClick(ByVal Cancel As msforms.ReturnBoolean)
                                                
  On Error GoTo errhandler                                                                                                                    
  Application.FollowHyperlink "https://infogeo3.vsj.ca/io/Ionis/Requete2/Edit?requete_id=" & tableau.List(tableau.ListIndex, 2)
                                                                                                                      
End Sub

Image of the interference where Table listbox is at the bottom.

0

There are 0 best solutions below