VBA display pictures in a table

[cyrilbrd]

Hi,
Using formulae and Name Manager I am able to display one picture based on the content on one cell.
However, this does not help as I am looking into populating a table (few to several rows, this may vary) with pictures based on the content of [@[Reference]], thus allowing several rows to be populated independently based on user input.
The pictures could be either:
-in a folder located on C accessible via a path.
-located in the same workbook if it would be easier.

The present setup consists of:
(1) one worksheet with two columns, Column A is the reference code and Column B is the picture inside a resized cell
(2) one worksheet with a table where the references are identified in each row via Data Validation List and another Column where we would want to see the corresponding picture(s)
Any advice on how to proceed would be appreciated.
Again we are open to suggestions and are flexible with the setup.

 

[RoryA]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

VBA display pictures in a table

Hi, Using formulae and Name Manager I am able to display one picture based on the content on one cell. However, this does not help as I am looking into populating a table (few to several rows, this may vary) with pictures based on the content of ], thus allowing several rows to be populated...

www.vbaexpress.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[cyrilbrd]

@RoryA absolutely!
However this is the forum I am/was the most active with.
Link option not possible in other forums due to my minimal input (forum rules)
Further, far from me is the intent to 'violate' or cause a 'problem'.
Solution found is to use =image()
No VBA solution has been proposed to date.
One "solution" was to use ACCESS instead of EXCEL.
Thanks for the reminder.