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

Hi Niall

I've done something similar to this in the past whereby the user would select an item and a related hyperlinked picture would display on the screen.

I have all my pictures stored on the local machine in a folder called "Inventory Pictures"; within this folder, I have subfolders called "Kitchen", "Dining Room", "Living Room", etc, etc.. Within those subfolders lives the pictures for each of those rooms.

I'd think my "Inventory Pictures" would relate to your "Report Pictures" and my individual rooms (eg: "Kitchen") would relate to your individual reports (eg: "BalanceReport").

From your sample file, I'd assume you have .pdf files and/or .xls files assigned to each report. Let me know if my assumption is correct (or not).

Building the files and then the hyperlinks takes a significant amount of up front work on your part. Are you interested?

Hi Niall

Try zipping the file then upload.

Why jpeds? Get some free pdf software , save reports as pdf into a special folder then open the report(pdf) from the userform

Hi Niall

Is this assumption correct?

From your sample file, I'd assume you have .pdf files and/or .xls files assigned to each report. Let me know if my assumption is correct (or not).

Hi Niall

Report1 Worksheet is blank. You do have an image of a report in UserForm1. This single image is what makes your file so large (2,000 KB for that image alone).

Hi Niall
I'm attaching a file for you to play with to see if it's something you can work with. The report files are NOT included in the workbook as I believe that'll make your file huge.

There's a button on ReportLookp sheet that'll create a folder called "Reports" in the same folder as the workbook resides. Within "Reports" folder, a sub folder will be created for each of your report names. Place your files in these sub folders (try two or three just for the exercise) then run your Report Lookup button. You'll get a screen that looks like this shot1.jpg Click on an item in the Report box and you'll get a screen like this shot2.jpg. Click on an item in the Output box and the file will open.

I just noticed I didn't remove the View Report button. It's inactive and should have been removed. If this works for you, we can clean that up later. Let me know of issues.

I forgot to mention, in the GetFilesMod, you'll need to change this

Please Login or Register  to view this content.

Hi Niall...I see we were posting at about the same time...did you attach a new file? f so, to what post?

Hi John,

Have awful broadband tonight and thought it was attached.

Apologies.

Niall

Hi Naill

I don't see this

I have define Report 1 to A2 report

How/where have you defined this?

Hi Naill

Right out of the box? Amazing! Glad it works for you. Play with it...let me know of issues. When you're satisfied, please mark your thread as solved.