Import spreadsheet data into an Excel UserForm

Hello-- in an Excel project that I'm working on I have a userform that contains a MultiPage control. On one of the pages I want a copy of a data table that I have in a spreadsheet. Is there any way to do this? I've done some googling and I've seen references to "Spreadsheet Controls" but haven't been able to make much sense out of it and there don't seem to be too many resources on it. I don't need to have the ability to manipulate the data once it's in the UserForm or anything, I essentially just need a snapshot of the data table on one of the pages of the MultiPage in the UserForm.

Thanks in advance for your help.
Jeff9687Asked:
Who is Participating?
 
Rory ArchibaldCommented:
If you just need a picture, you can use an Image control and some code to do that - see the PastePicture.zip file here: http://www.oaltd.co.uk/excel/default.htm
for the sort of code required.

If you need specific assistance setting that up, please post back with a few more details such as which range you want copied and/or a sample workbook with your form in.

Regards,
Rory
0
 
Jeff9687Author Commented:
I'm essentially looking for a snapshot of a particular spreadsheet range to show up in a userform, for example in that PastePicture.zip example, instead of the chart, I would need a snapshot of the data range A8:A19 in the userform. I've figured out how to use the spreadsheet control but it turns out that it's not really what I'm looking for... I need something that would pretty much look like a printscreen of the spreadsheet with RangeA8:A19 cropped out and placed in an image control somehow.
0
 
Jeff9687Author Commented:
nevermind, i got it:

http://www.mrexcel.com/forum/showthread.php?t=83429

thanks though, you got me on the right track w/ the idea of the image control

0
 
Rory ArchibaldCommented:
FYI, you can also copy ranges  - Range("A8:A19").CopyPicture for example, and then use the pastepicture code to put that straight into the Image control. Much cleaner than the charts and exports.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.