Get image shape from a sheet to image control in another sheet

Hi EXCELlent people!
I am working on a recipes workbook and I need to ask for your help in order to retreive an image (shape) from a sheet and show it into another one.

I'll explain... I have a sheet with a "database" containing the name, category, author, ingredients, preparation, date inserted and a photo of each recipe.

I inserted all the data in the sheet via userform.

So I have a nice long list of recipes, one per row, with a photo for each recipe in the last column (column 7 or G).

I am already able to get all the values of each recipe in another sheet into textboxes, calling from a populated combobox dropdown list with the recipes names.

But I can't figure out how to get the right photo for each recipe when showing the data.....

Please Login or Register  to view this content.

Until now I can only show the first photo.... how can I get the right picture for every recipe I'll call from the combobox?

Any help will be really appreciated.


PS I tried to post here early in the morning but my post did not shows up until now.... may be I did something wrong... sorry if is double. My bad...

Yesterday morning I asked for help on MrExcel.com but nobody answered me. After spending almost all night searching online for a solution by myself, early this morning I also asked here on Excelforum.com. Same luck... nobody answered me.

HTML Code: 

HTML Code: 

As I like ozgrid and I visited a lot before I decided to register there and ask there.
Actually I thought cross-posting was asking a question in another member post. I am really sorry about all of this.

Rule 08: Cross-posting Without Telling Us

Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

No further help to be offered, please, until the OP has complied with this request.

Excuse me Miss AliGW... and sorry to everybody for my act of stupid desperation. Do I still have any chance to get help or I am already buried?
I have added my "confession" in my first post...

Can you post an example file with some images and the sheet with textboxes etc..

I have to warn that the recipes book is in Italian.... what else? )
There is only one recipe because of the file size... you will have to kindly insert another couple of recipes to test it.
Click the button "INSERIRE NUOVA RICETTA" and fill the fields... Ingredients must be inserted before final submission in the list... and if you do not load a foto, it will be replaced by a dummy wich is in the sheet categorie

If you rename every ImageControl the same as your recipyname then you can use something like this.

Please Login or Register  to view this content.

Been playing around with your file. Take a look and let me know.

Wow thing are really different from my attempt... actually past the limit of my VBA knowledge.......

As explained to amberle the line with OLEObject pops up the error.

I can see my NameOfPhoto code in module1 but it seems you are not using it...

Actually I think is a good way to go...
I can see you too works around the name of the pictures in RICETTEDATABASE.
So no matter the exact name of the picture, since I know it I can call it.

In my case instead of the recipe name I will have Image1, Image2 etc but all in the right place.

Why in my code I get an error: Object doesn't support this property or method?

The string myphotoname is exactly Image1 or Image2 etc so why when is used in the line below with RICETTEDATABASE gives me the error?

Please Login or Register  to view this content.

It is like the string myphotoname is not replaced by the picture name... and it is not working, because the script is looking for a picture holder named myphotoname wich does not exist.... but in the message box the name exists. Need to find a way to replace the sting myphotoname with the value on column 7....

It will only work if you increase the row height.
So each row has to be as high as each image.
Can't attach a file with 2 images in it so PM me your emailaddress so I can send you the file that way.