Load picture in Userform from images in the same workbook.

Hi,

Im very new to this forum and can someone help me with this task.

I have a workbook with images and have created a userform using VBA in the same.

I wanted to load a picture in the userform from the images on sheet 3.

Any help is greatly appreciated.Thanks in advance.

regards,
Prakash

VBA code in Module1 in the attached Excel 2003 file will allow you to copy
an embedded image in the workbook to the clipboard. The image can then be pasted
into the form's image control.

The developer of this code is documented in Module1.

I added the form and images to demonstrate that it works. Image selection is
controlled in the combo list change event.

If you decide to use this solution, as you test it, you may want to ensure
that a copied image is no longer in the clipboard after the application is closed.

Helloe,

First of all thank you so much for taking time to help me with such elaborate reply and an example file.

But is there any option without using a combo list box this can be done?

Because i have created a userform as a tool for my company to access different hyperlinks linked to a command button.

I would like to create a picture box beneath to have images keep changing as they work on other controls in the userform ( like a advertisement board) where the images of company will be saved in the excel sheet and it keeps changing with a specified time interval.To make imges change with specific time interval i ve done it with " kernel32" library. only thing i want to do is to have images load into the picture box and keep changing.

I tired this code but not working.

Me.userform2.picture1 = loadpicture(thisworkbook.worksheets("Sheet2").shapes("logo"))

Thanks in advance for your help.
Regards,
Prakash.

I can't help you much more than with the example I've given you. If this were my task, I would
research using a timer for Windows applications. I’ve never used a timer in Excel, although I did
use it in Visual Basic courses. You would use the timer to periodically execute code similar to the
code in my example combo change event, but coded to cycle through your available images.

Man, that solution was pretty awesome.

I'm stil trying to understand what you did, however, I'm still capable of making it works!

Thanks Man! You're Awesome³³³!