Controlling the position of a Text Box shape within a sheet

Hi,

I am working in Excel 2016 for Mac and have added a text box to a sheet, thus: Insert -> Text Box

To display the content of a range in the Text Box, I've selected the Text Box and then entered =$A$1 in the Formula Bar. $A$1 contains a concatenated list made from values in a range of other cells, separated by several instances of CHAR(10) to produce a list containing Alt+Enter line breaks.

Now I want to write or produce as a formula result, say, the address $D$22 in cell B2 and with that cause the upper left corner of the Text Box to be positioned in cell $D$22. If I change the address written in B2, the Text Box will move again.

I suppose this would be possible with a user defined function in VBA or something. Can anyone please take a look at this?

http://www.mrexcel.com/forum/excel-q...cations-2.html

Maybe this link will help