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.

[June7]

I recommend building an Access database instead of trying to use Excel like a database.

[cyrilbrd]

I recommend building an Access database instead of trying to use Excel like a database.

Noted with thanks.
Any proposed existing form that I could use as a template for such endeavor?
Or do you suggest to go thought the basics prior to tackling such work?
The final objective being to simply print the pictures, so the form would be quite ephemeral and would change based on needs.

[June7]

Sounds like this would be a very small project. No, I don't know of any template.

Suggest you spend a solid week studying an Access introductory tutorial book to get the basics.

Use a form for data entry and report for printing.

[georgiboy]

If you have Excel 365 and you host your pictures online you can use something like the attached. Exel recently added the IMAGE function that will display an image in a cell of a table.

[cyrilbrd]

Will use =IMAGE()

[Paul_Hossler]

Like many / most /all Microsoft initial release features, I find it lacking since it can only 'link' to a http URL


Possibly this may help if you have local files

https://www.youtube.com/watch?v=0NArag0pV7I

[cyrilbrd]

Like many / most /all Microsoft initial release features, I find it lacking since it can only 'link' to a http URL


Possibly this may help if you have local files

https://www.youtube.com/watch?v=0NArag0pV7I

Thanks for the input.
Files are presently on Onedrive personal, the reason here is to ensure accessibility regardless of location.
OneDrive Pro is not used due to issue pertaining to Sharepoint / Excel.
Our local Microsoft reseller has so far been unable to give us a permanent solution for this, which is a shame considering the associated cost per user per month.

Considering the volume of items with picture being less than 10,000, it might indeed be a small project.
I am still looking for the solution that will provide the simplest approach while being shareable without loosing functionality.
Thanks again for the input, much appreciated.
=IMAGE() to date provides what the end user needed.