to open pdf when clicking command button after selecting list box

[ajaar]

Dear Friends,

I have below code to open PDF file from the list box, which is perfectly working with single value, when value of list box is changing, i wanted to change the path accordingly.
list box name is rrno, when i tried to change the code"\Me.rrno"&".pdf, but it is not working.

Any help please, i googled a lot, not succeeded this time.

Appreciate your help.

ThisWorkbook.FollowHyperlink "C:\PDF file supportings\1052555.pdf"

Regards
Ajaar

 

[Deepak]

Pls share your excel having the said listbox.

 

[ajaar]

Hi Deepak,

Thanks for the reply. Please find the file attached here with.
listbox name: arrno
when i select on show button i want to open PDF file. all PDF file saved in the same folder.

Thanks
Ajaar

 

[Graeme]

Have you tried explicitly using the Text property of the listbox like this:

ThisWorkbook.FollowHyperlink "C:\PDF file supportings\" & Me.arrno.Text & ".pdf"

?
Does this also not work?

 

[Deepak]

All is almost well there!!

Just little modified the same.

Private Sub CommandButton1_Click()
With Me.arrno
    If Not .ListIndex > -1 Then MsgBox "Pls select a file name", vbCritical: Exit Sub
    ThisWorkbook.FollowHyperlink "C:\PDF file supportings\" & .Value & ".pdf"
End With
End Sub

or

Yours.

Private Sub CommandButton1_Click()
ThisWorkbook.FollowHyperlink "C:\PDF file supportings\" & Me.arrno & ".pdf"
End Sub

 

[ajaar]

Hi Friends,
Deepak, Graeme.. thank you so much.

thanks
Ajaar

 

[Deepak]

Hi Friends,
Deepak, Graeme.. thank you so much.

thanks
Ajaar

Welcome!! Likes pls.

 

[Graeme]

You are welcome.