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!!