PDA

View Full Version : Displaying Image on a Userform



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!

rory
11-29-2007, 06:45 AM
Re 1, what kind of shape is it?
Re 2, set the Image control's Picture property to Nothing.

bbk5
11-29-2007, 02:26 PM
The shape is a picture that I inserted into the Worksheet from a file.