single click function on the excel cell

Experts

I have used one SAP BPC function in the excel cell =EVMNU() , to run this function I have double click on it.

Now my requirement is that I want to run this function via VBA macro , where I am not able to run it 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 mouse or is there any setting in excel which will trigger above function with single click.

Thanks for reading my post!!

I'm not much of a programmer so I can't give you any code that will do this, but...

There are a couple of event macros that could trigger your function.

There's a Worksheet_SelectionChange event which is the equivalent of a single click event. When you select a cell it's the equivalent of a single click event.

There's also a Worksheet_BeforeDoubleClick event which is a left double click event.

Ask over in the VBA programming forum.

Good luck!