VBA Userform and Pictures

**kumarinrajoo** · 09-02-2013, 05:04 AM

Hi all,

I need some help with a sample excel database. In one userform there is a combobox with a list of names and below this list is a image field. I want to be able to select a name from the list and then display their image in the image field. Any help or sample downloads would be highly appreciated.

Regards
Kumarin

**hulpeloos** · 09-02-2013, 08:15 AM

in cases like this an example workbook attached to your post would help this can be done by using the advanced options when you post

that being said you will need to work with

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

**kumarinrajoo** · 09-02-2013, 08:36 AM

Book1.xlsm

Herein attached is what I have started with. Sheet one contains the info.

Tnx again...

**hulpeloos** · 09-02-2013, 03:01 PM

well i was hoping the pics would be stored somewhere rather then be in the workbook as shapes

this is for pics at some give location to already give you a start

Please Login or Register  to view this content.

**Leith Ross** · 09-02-2013, 06:02 PM

Hello kumarinrajoo,

The attached workbook will display the picture for the person selected on in the UserForm Image control. This is done by copying the picture to the clipboard and pasting it into the Image control as a Picture object. The API calls used to do this are for Windows systems using 32 bit operating systems. If you plan to use this on 64 bit platforms, the API calls will need to be changed. I have them if you need them.