I would like to use an autoshape as a popup linked to a cell. The autoshape would display the text in a reference cell from another worksheet or from a hidden column on the same worksheet. The autoshape would automatically contain updated text when the reference cell is updated. Like a comment, the autoshape would be invisible until user scrolls over the cell it is linked to.
Is there a way to do this without creating a complicated macro?
Is there a way to do this without creating a complicated macro?
