Auto change Picture Based on cell value. Please

[AmirSoft]

Hi Experts of Excel Forum.
May God bless you all. Please give sometime to this thread.

I am a teacher in a college. And there are many students in my class.
I have to print files of student with their pictures.
And this is too difficult to import every picture and then delete the picture and then import new one.

So I make a example sheet to show you what I really want.
I have Pictures in "C:\Amir\"
And I want when I enter roll number of student and then press the button. It should change the picture.

I shall be very thankful to you.

Regards
Amir

[sktneer]

You may try this.....

Please Login or Register  to view this content.

This code will work if the picture of the students are saved with their names. So as per the sample file if the file C:\Amir\Amir Shahzad.jpg is found, the code will work and insert the picture of Amir Shahzad in D4 else it won't insert a picture.

[walruseggman]

Working with pictures in VB isn't my forte, but try this.

It assumes that the pictures are named the same as the Roll No you're typing into B4. You'll also need to change the "Sheet1"s to whatever the name of the sheet is that you want the pictures on.

Please Login or Register  to view this content.

[AmirSoft]

Hi Neeruj and walruseggman
Thanks a lot to both of you.

You did great job. I am very happy with your great answer

[sktneer]

You're welcome. Glad I could help.