Populate PDF files in listbox on usrform based on selected device from combobox

MKLAQ

Active Member
Joined
Jan 30, 2021
Messages
398
Office Version
  1. 2016
Platform
  1. Windows
Hello
I search for maro to do many requiremns .
1- combobox1 should populate devices C ,D,E
1- combobox2 will show all of folders for slected device from combobox1
2- the folder is selected from combobox2 based on selected device from combobox1 contains PDF files , also contains subfolders Naturally contains PDF files
3- should populate folders in combobox2 based on selected device from combobox1.
4- when select folder from combobox2 if the selected folder contains folders then populate the subfolders in combobox3.
5- when I select subfolder from combobox3 then should populate PDF files in listbox1 .
6- if I select folder from combobox2 and doesn't contain subfolders in combobox3 then populate PDF files in listbox1 based on selected folder from combobox2.
7- when populate PDF files and click for selected item from listbox1 should open the PDF file.
8- when open PDF file I would show message to print out the file , if click ok then print out . if click no then keep the pdf file keep showing without print out.
thanks in advance
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Forum statistics

Threads
1,216,119
Messages
6,128,941
Members
449,480
Latest member
yesitisasport

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top