asked on

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.

ASKER CERTIFIED SOLUTION

Rory Archibald

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jeff9687

ASKER

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.

Jeff9687

ASKER

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 Archibald

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.