Adding scroll feature in an image that appears on a userform

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 have a scroll feature on the userform. This image is generated by the 'CameraTool' and is of a table on a spreadsheet (which changes sizes), and displayed on a userform. I am planning to have the image change sizes according to the number of visible cells, but keep the picture box on the userform the same size, and have a scroll feature rather than the image be compressed into the display box. 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

Hey Andy, Thanks for your help.

I definitely started with a complex question, and after looking at the alternative it was more complicated than it needed to be.

With the multicolumn listbox, I am planning to have a a loop that runs i=1 to NumberOfRows starting at Cell A1; having an If statement in the loop: If A[i] is visible, then copy the rows values to variables that will display in the listbox, else next i.

Does that sound like a good approach?

Much appreciation,

Adam

Andy, thanks for heads-up. Looks like I've run into some sort of problem, possibly caused by a formatting issue but probably an "Object" issue.

I've created another post and wondering if you could have a look. http://www.excelforum.com/excel-prog...ml#post3908575

Thank you very much for your help.

Adam