VBA ListBox selected item

[QasimMGM]

Hi,
I,m new to VBA and started my first user form with buttons and list box, I wrote the code below to open a file in my laptop that named after the first item in the selected line in the Listbox:

Private Sub CmdFindLetter_Click()
Dim i As String
i = ListBox1.Selected(0)
ThisWorkbook.FollowHyperlink "D:\Tests\Letters\L-" + i + ".pdf"

End Sub

but I got this message (image attached)

Any solution?

 

[Yongle]

Welcome to MrExcel
In future please click on VBA icon and then paste your code inside the code tags which appear

[ CODE=vba ] paste your code inside the tags [ /CODE ]

If the code requires highlighting ( as I have done) click on RICH icon and paste your code between the tags which appear

This method works for me

Private Sub CmdFindLetter_Click()
    Dim i As String
    i = ListBox1.Text
    ThisWorkbook.FollowHyperlink "D:\Tests\Letters\L-" & i & ".pdf"
End Sub

 

[QasimMGM]

Welcome to MrExcel
In future please click on VBA icon and then paste your code inside the code tags which appear

[ CODE=vba ] paste your code inside the tags [ /CODE ]

If the code requires highlighting ( as I have done) click on RICH icon and paste your code between the tags which appear

This method works for me

Private Sub CmdFindLetter_Click()
    Dim i As String
    i = ListBox1.Text
    ThisWorkbook.FollowHyperlink "D:\Tests\Letters\L-" & i & ".pdf"
End Sub

Thank you very very much..
This works for me.
I really appreciate your help..
further question if you allow.. this code will take the contents of the first column of the selected item of the list.. what if I want the 2nd or 3rd item..?