Double-click on cell to run macro

I am using an addin that requires double-clicking on a cell containing a function in order to run that function that retrieves data. The data is then presented in a table adjacent to the double-clicked cell. Each time the cell with the function is double-clicked, the data updates.

I would like to instead create a macro, so I can combine the action of double-clicking with some other code and assign this new macro to run from a button or key combo instead of manually having to double-click with my mouse/touchpad.

I have tried searching for a solution, and have come across and tried the following Application.DoubleClick method, but this does not seem to work for me:

  Sheet1.Activate
    ActiveSheet.Range("A4").Select
    Application.DoubleClick

For some reason, all it does is select a couple of other cells but doesn't run the function that updates the data.

I am only new to VBA programming, so any help is greatly appreciated.

TIA.