MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by PHISHFN on July 12, 2001 2:58 PM

Is there a way to embed a section of a sheet on a userform?

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
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