Hi Experts

There is a =EVMNU() function, to run it I have double click on it.

Now my requirement is that I want to run this function via VBA macro , where I can't since there is no function which will double click on the cell and also there is no sendkeys for LEFT Mouse CLICK ..

How can i achieve this double click with macro or is there any setting in excel which will trigger above function with single click.

My friend suggested to use function Worksheet_BeforeDoubleClick , not sure how to use it.

Thanks for reading my post!!