Opening PDF & JPG files with USERFORM VBA

[dellehurley]

Hi
I have googled my heart out over the last couple of days and tried 100's of different things but nothing is working so I am hoping one of you fine people can help.

I have created a Database with a user form. I need to be able to open the files which names I have pointed out on the left hand side. All the files are all PDF and Jpg files. They are all located in the one folder the same folder where this database is located. New files are always being added.
The combobox pointed to on the right (cmbFileCode) does not need to be there and maybe not the command button names Open File either, if you can make it work without it.
Currently the combobox (cmbFileCode) is dynamic and updates as the database is added to from the info on Worksheet2 (Database)

The file can be found here Link to Database File via Drop Box
Thanks Dannielle
My apologise if my code is messy - I'm a newbie.

 

[yinkajewole]

you want to open them externally?

 

[yinkajewole]

what is their folder source?

 

[dellehurley]

Hi,
Yes I would like to open them externally and the folders address is
C:\Users\delle\OneDrive\Documents\Genealogy\!Family Tree Files and Photos!\
If it is an issue being in OneDrive I can move it and back it up another way.
Thanks

 

[dellehurley]

Thanks for your interest and offering to help but I have managed to sort it out.

 

[yinkajewole]

that's alright