need procedure to open PDF file as preview based on showed data in listbox on userform

[Abdo]

Hello,
when run the form will show data in listbox1 , and i have sheet calls PREVIEW . so when I click commandbutton1 I would copy data from listbox1 to PREVIEW sheet start from row16 with create borders automatically and open pdf file directly for data in PREVIEW sheet. but should clear data and delete borders from row 16 before brings data from listbox1 and create borders again.
thanks.

 

[bobsan42]

I don't know if you can do this in a sheet.
But if you a ok to view it in a userform check this link.

 

[Abdo]

thanks.
I don't want use WeBrowser .
I bet there is way. I will search in the internet maybe have luck.

 

[bobsan42]

Let us know if you find one. Good luck.