bbk5
11-29-2007, 03:35 AM
This is a two-pronged question:
1) Is it possible to take a Shape object stored in a Worksheet and display it on a Userform? Right now, I am using the Image object to display images but it seems to only work if you load in a .bmp or .jpg from a file. I just want to grab the image from the Worksheet.
2) When using the Image object to display an image located in a file, is there a way to clear the image that is being displayed so the object isn't displaying anything?
Thanks for the help!
1) Is it possible to take a Shape object stored in a Worksheet and display it on a Userform? Right now, I am using the Image object to display images but it seems to only work if you load in a .bmp or .jpg from a file. I just want to grab the image from the Worksheet.
2) When using the Image object to display an image located in a file, is there a way to clear the image that is being displayed so the object isn't displaying anything?
Thanks for the help!