I've created a simplified "summary" worksheet and a raw data worksheet from a
survey. On the summary worksheet, I display the data from the raw data in a
"user friendly" format and I want to display [if not "" null] any text
comments from a cell in the raw data worksheet, to a text or auto shape box
on the summary sheet.

Clicking on a link, or command box, etc. Once you have viewed, click on
another box(?) to hide again.