ListBox Call to ignore blank cells

[nigelog]

Please Login or Register  to view this content.

I am attempting to attach a list of scanned training details to a Userform and use a Double_Click Event to open the pdf's with the following

Please Login or Register  to view this content.

Was working fine when I had an entry in the fields the listbox retrieved to make sure they loaded.

When I left then blank because that record only had one pdf to list, the first code stopped because there was no entry. How can I ignore if it is blank??

What would even be more preferable would be that I could list the pdf files contained in the individuals sub folder, any ideas??

[cytop]

What would even be more preferable would be that I could list the pdf files contained in the individuals sub folder...

Assuming you do know the individuals sub-folder...

Please Login or Register  to view this content.

Call it using something like

Please Login or Register  to view this content.

Rather than just limiting the procedure code to PDFs, pass it in as the file mask - you may need to load a listbox with a different type of file later...

[Arkadi]

assuming you are referring to the double click event:

Please Login or Register  to view this content.

[nigelog]

Thanks for the input

Used a combination of both and works perfectly calling all pdf files

Workbook attached for reference. Just change filepath