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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.
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

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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.