I have seen variations of this requests on this forum, but can't find one that matches my exact request.
I have a column of cells that contain very long job descriptions or strings of text. I want to keep the column with relatively small, but give the user of viewing the text in a message or text box. Therefore, I would like to click on a cell that contains the text and have the text appear in a properly sized msg or text box. You should also know that the cell containts a formula with a vlookup function in it. So I don't want to show the formula within the cell; I want to show the results of the formula which in this case would be text. I wouldn't want this macro to produce a text box if the formula in the cell produced a blank (or ""). Thank you for reading and bearing with me on my first post/

Warm regards,

Tony

Using Excel 2010