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?
Bookmarks