Posible to insert/create multiple shapes in a cell and hyperlink each shapes according to given criteria?

[paolomedina]

I've been trying to search for days already for solutions or idea how to do this in Excel VBA, however I cannot find a similar scenario for my needs.


Here's the idea:


I have the following table as reference for the hyperlinks:
<img src="https://i.stack.imgur.com/0BX0E.jpg" width="344" height="274">


Now on a separate column, I want to create a "+" shape in each corresponding next column of the reference number and make each shape a hyperlink in reference to the first image provided. It may contain one or more shapes in one cell until all the links for that reference number has been made.
<img src="https://i.stack.imgur.com/ZHpab.jpg" width="247" height="140">


I want to do this in VBA because multiple links in single cell is not possible in Excel and hence shape/image/symbol hyperlinking is the only solution I can think of. I am clueless where to start or how to start.


I hope someone will be able to direct me as I am still learning on Excel VBA. Thank you in advance.

 

[paolomedina]

Oh by the way, this my new post in this forum but I've been reading some tutorials/answers long time before in MrExcel.com but just decided now to register.
Should I need to correct something in my initial post, please tell me so I can edit and comply to the site's Rules & Regulations.

Now, going back to my query, how should this be approached? What's the best approach for this? Multiple arrays then loops? Collections? Range reference?