Put images from worksheet onto userform 1

[DrBowes]

Hi, ideas for this one are appreciated.

I have a worksheet with several images on it (gifs pasted onto the worksheet). When a userform is opened I would like a random one of these images to be used as the image on an image control on a userform.

Can easily select a random image from the worksheet, but how can this be placed into the image control?

 

[fumei]

I don't think you can. The image that shows in the image control is explicitly stated, as a property. It is a file, not a selection object. I do not think you can paste into a image control from a selection.

object.Picture = LoadPicture( pathname )

Pathname is required.

Gerry

 

[IvanMoala]

Have a look here for the underlying code to do this

http://www.xcelfiles.com/VB_Quick17.html

It shows he basics of saving an Image

Ivan F Moala

http://www.xcelfiles.com

 

[DrBowes]

Ivan

I have been on your site a few times before - it is awesome.

 

[fumei]

Yes, great site!

Ivan, you still can't get the image onto a UserForm except by saving the image as a file, and then loading it, right? It still must be explicitly loaded as a file. Pathname is still required, yes?

There is not a way to paste directly, as the original post asked.

Or am I missing something?

Gerry