I am trying to display the contents of a range of cells into a floating text box dynamically as and when the focus moves from one cell to another.
I have designed a dashboard, where the height and width of the range of cells are fixed. The problem arise when the cell content grows in size as it gets wrapped in the cell and all the contents are not fully displayed. Since the worksheet is protected, I am trying to display the cell contents into a floating text box below the range area that is large enough to display the full cell contents.
I appreciate your help to achieve this preferably without using VBA if possible.
-Godwin
I have designed a dashboard, where the height and width of the range of cells are fixed. The problem arise when the cell content grows in size as it gets wrapped in the cell and all the contents are not fully displayed. Since the worksheet is protected, I am trying to display the cell contents into a floating text box below the range area that is large enough to display the full cell contents.
I appreciate your help to achieve this preferably without using VBA if possible.
-Godwin