get text value inside the shape where line arrow started (excel VBA)

[xpost][/xpost]

Hi, I am still learning VBA. I need help on the above. Say, the square shapes are msoAutoShape. I need a code that will loop through all the said shapetype and get the text inside the shape where the line arrow started and where it ended.

The expected output:

Started on "test1" and ended on "test2",

Started on "test3" and ended on "test4",

maybe just put it in msgbox. Any simple sample code will do.

I have attached the .xlsm file for you. Thank you in advance.

Thanks for your reply, Roy. Yeah, don't want to complicate it either but it is the requirement so I am trying to find a solution.

Hello, all good now, I got an answer.
Thank you again for your time.
Take care