Showing preset Worksheets when Cmd Button clicked in user form

Hi All,

New User back again asking for advice. RoyUK thankfully helped me out greatly today. The question I have now is what is the best way to get a command button to open up a pre defined worksheet that contains a jpeg. The result will be based on what is selected in the combo box.

i.e. If I select Auditing report I would want, when the command button is clicked, the image I have created with a jpeg of the report to show on screen.

Is there an easy way of doing this as I will probably have a different report to show for each of my combo box selections. Can I make the multiple reports on individual worksheets or would it just be easier for each selection to call a jpeg stored on the local computer.

Any steering would be very much appreciated.

Regards,

Niall