multiple dynamic picture on excel

[sergenelles]

I want to create a flexible report that I can print out and give my customer.
I make a list of product we sell, and I like to have the picture of the selected product on the left.

I have the VBA that can make change the picture, but i can make it work for only 1 picture has the "worksheet change" vba can only be used for 1 time

I don't know how to make it repeat for all the needed cells.

such system is so good for all people who need many pictures to be updated.

thank you

serge

 

[Datsmart]

I first used the suggestions on that site using Excel 2000 and it all worked as listed.

I understand your desire to not "contain" all the picture objects in the workbook.
Never tried that but will watch this post for ideas and will play with it myself as time allows.

 

[sergenelles]

I would believe if you need to make a report of 20 items with pictures,
and the items are always different from the first to the second or next time.
The time consuming to insert all these over 100 of pictures, and the size of the excel file will become very heavy for the computer to open.
Definitely such way is good.
I m surprised no one fond a solution because I see many people that could be interested.
To make quotation, invoices, or also like me, I make my work in 3 languages, so I need a lot of flexibility.

anyhow, thank you to people who took interest, cheers, serge

 

[Datsmart]

Joe Was has some old code, (4 years ago), that pulls pictures from a file.
http://www.mrexcel.com/forum/showthread.php?t=263365
Give that a shot.

 

[sergenelles]

thank you so much for info. I will ask him for explaination of cells definition to allocate the right way.
thank you
serge