Hello All

i am facing a problem and i wish from you to help with it

The Problem :

i have a userform with listbox1 & CommandButton1 and i am using the listbox1 to select file name from Sheet5 > Rowsource "d1:d20" and to open it as pdf

i used this code

If Me.ListBox1.Column(0) = "cie_plant_result_list" Then
ThisWorkbook.FollowHyperlink "C:\Result\cie_plant_result_list.pdf."
and it work perfect !

but i am trying to get second file to Listbox1.column(1) for example :

If Me.ListBox1.Column(1) = "edc_plant_result_list" Then
ThisWorkbook.FollowHyperlink "C:\Result\edc_plant_result_list.pdf."
End If
after press the commandbutton1 this error display !

listbox problem.jpg

i really appreciate your help