Dunno whether it'll be today, but if you'll allow a little freedom with the requirements I can think of a few ways to do something similar. There are three events you can try:

1) BeforeDoubleClick requires the user to double click on a cell. I've used this one.

2) BeforeRightClick is activated when the user right-clicks on a cell, before the menu pops up. This enables you to add an item to the menu, or to "Cancel" the menu and do something else instead. Probably not what you want, but it's available. (I've never tried it.)

3) If you really want a click, I've never used it but you probably want the Worksheet_SelectionChange event.

That's the first part. Now, what your program will do when it's triggered is another set of choices. The obvious one is to put the data in a MsgBox. Or you could fill the data in some predesignated cells somewhere nearby, within the user's field of vision, probably just to the right.

Or you could update the target cell's comment, and let the cursor's presence over the cell trigger the comment to pop up. That might work; I'm not sure. But it brings up another possibility: How about having the required data always in the comment? Then you don't need any fancy events in the presentation sheet; you just need a Worksheet_Change function in the data sheet, so that every time you update the data there it updates the comment in the presentation worksheet.