Inputting pictures into UserForm

**DCHill** · 05-06-2009, 11:04 AM

Hi all

I discovered this sample database sheet (attached) on the forum I wanted to ask if a picture can be linked included? i.e. when entering a new record a picture (stored in a directory) can be added and linked to that record. Then when reviewing the records the picture is then displayed.

Can anyone help as my VBA skills are limited.

**royUK** · 05-06-2009, 01:18 PM

You should be able to load a picture when a name is selected, I'll look at an example later

**DCHill** · 05-07-2009, 07:40 AM

RoyUK

Did you find that example?

**royUK** · 05-07-2009, 01:22 PM

I haven't had time yet, probably be the weekend before I have enough time to combine the two examples

**DCHill** · 05-07-2009, 06:11 PM

RoyUK

As and when you have time but in advance many thanks.

**royUK** · 05-09-2009, 10:04 AM

I have added this feature to the sample form, the images need to be stored in a sub folder called images in the same folder that the workbook is in. Some sample pictures are included in the zip file.

I have also updated some of the existing code

http://www.excel-it.com/vba_examples.htm