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.

Hi,

I used the "DoubleClick" method and activated a filter in the "Source" sheet.
When you dbl click a date this will fire the code to set the filter to the date selected.
It will then take you to the "Source" sheet for review.
The user will then after review click on the tab to take them back to the "DashBoard".

Attached Files

Example-3.xlsm (16.1 KB, 11 views)