Using picture to display table from worksheet on userform; need help modifying picture

Hello,

I believe this to be a fairly complex question, but wanted to see what you guys have to say about it.

ExampleFile.xlsm

So, I need one functional aspect of the picture changed: 1. The picture needs to adjust size to include all the table's visible rows. It has been easier said than done for me because this image is generated by the 'CameraTool' and is of a table on a spreadsheet (which changes sizes). It was the only way I could find to have an image of a table located on a spreadsheet to be visible on a userform.

The whole workbook is intended to be a vacation calendar for a company department, where employees can input their vacation requests. The code for producing the image is located in Module1, and the actual image is produced from the Vacation Schedule tab. The userform the image is displayed on is accessed by running the macro, selecting 'EagleFord' and "Johnny, Archie" and clicking "Edit / Modify.."

This is intended to show the vacation requests the person has already submitted.

I appreciate your time and thoughts.


Adam

Andy,
Thank you for your help, and you're right. As simple as I hoped.

Adam