Shapes

Hello everyone,

I have excel 2019.

I have 3 shapes on sheet 1 of my workbook. There are a triangle, a square and circle. To put these shapes in the workbook I I went to insert illustrations, then shapes.


Is there a way to convert a shape to text so that I can use a simple = formula to get the shape in cell a1 of sheet 2? I think the answer is no. Would you agree that VBA would be necessary to get the shape into cell a1 of sheet 2?

I used the macro recorder to find some code but I would prefer to use a formula if possible.

No, formula's return a result. They don't manipulate objects.

One can use VBA to look for a sheet cell(s) change event and act accordingly.

Thank you Kenneth. I found a custom paste that can link pictures. This solved my problem.