Archive of Mr Excel Message Board


Back to Edit in Excel archive index
Back to archive home

Embedding

Posted by PHISHFN on July 12, 2001 2:58 PM
Is there a way to embed a section of a sheet on a userform?

Re: Embedding

Posted by Ivan F Moala on July 13, 2001 6:38 AM

One way to do this is to copy the spreadsheet
range via shift Edit / Copy as picture
ie.
1)Select range or object
2) Press shift
3) Select Edit
4) Copy picture
5) choose Bitmap
6) Paste into mspaint
7) Save as bitmap or gif
8) import via std means into your userform

HTH

Ivan



This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.