Hi all,
I'm a first time poster so be gentle with me! By trade I'm a CAD draftsman, but I've been tasked with creating a dashboard tool for our team so I'm picking up VBA as fast as I can!
I'm sure I'll be back more than once with new questions but for now here's what I'm stuck on:


What I'm trying to do is display a PDF* (within the spreadsheet) that changes when i select a different option from a drop down list (which is cell C3)
All the pdf's will be stored in one folder. Let's call it c:\pdf"
The drop down list is town names preceded by a 4 digit code i.e. "0001 Coventry" or "0002 Bristol" etc but the pdf documents will only have the towns name not the numbers.

What would be really amazing if there was a way for the user to pan and zoom the image within its box, I guess if thats not possible I'll probably just put on a command button to link to open the full size pdf.

*If its not possible to display pdf's then I can use .jpeg



If you can help with any small part of this I'd be really grateful. Thanks in advance,
I'm Really looking forward to learning from you clever guys & girls!
Jonny