Hyperlink to a file on a list box

[Albano]

Hi,

How can I put a link to open a doc ou xls file in a list box item when is clicked.

Thanks

Albano

 

[Remou]

You can use FollowHyperlink.

 

[Albano]

Can you give-me an exemple of whow to do.

 

[Remou]

It depends on what is in the list box. Let us say it is the full name of the file, including the path, and that the listbox is not multiselect.

Private Sub lstList_Click()
    FollowHyperlink Me.lstList
End Sub

 

[Albano]

Works.Thanks