Double-click on cell to run macro

Thanks for your feedback, and for the help with the code tags.

I'm not sure what you mean by "move the code from the double click event". Can you elaborate?

Just to clarify, the addin is not mine. I can't access the addin code and am not trying to modify it. The addin is from the provider of some sharemarket software. The addin includes the function in the cell that I double-click to update a table of data. I'm not so concerned about the addin or the function in the cell.

I'm interested in understanding how I can code in VBA a double-click on the cell that contains the function so I can do this via a macro instead of having to do it manually.

Yes. AFAIK, the only way to run the function in the cell is to double-click on it with a mouse/touchpad.

I think (hope) I'm starting to understand.

Is it correct that when I double-click on the cell containing the function, this triggers a double-click event for that function that is also coded in the addin?

And are you basically saying that because the double-click event is coded in the addin, it is not possible to let the addin know the double-click has occurred (ie trigger the double-click event for the function) by using code in the worksheet?

another solution is that you can have a count in an variable, like one click +1 and another click +2.
then initiate the sub or whatever you want to do..
cheers

The addin is offered by Iress, an Australian provider of sharemarket software. Iress offers a desktop product used by most Australian stockbrokers, and many Australian online brokers offer a product called WebIress. WebIress includes an optional excel addin called WebIress Market Data Addin for Excel.

The addin creates a menu and provides access to a number of functions relating to sharemarket data including depth, trades, company options, historical prices, etc.

The function in the cell is:

Please Login or Register  to view this content.

where code is a name I have defined that represents a company's stock code.

When the cell containing the function is double-clicked, this particular function performs a web query and retrieves/displays data for a number of defined fields.

As I mentioned, the only way I currently know how to run the function and update the data is to double-click the cell with a mouse/touchpad.

As an example of what I am trying to do using VBA, I was hoping to find a way to perform the double-click and combine this with creating/updating a PivotTable that summaries the data retrieved.

Since starting this thread I have sent a query to Iress about this issue. I will post the details of any relevant reply I receive.

Thanks for your continued interest/efforts on this thread.

I sent a query to the addin provider about this issue.

They have confirmed that what I am trying to achieve is not possible as the data objects are not available for the addin I am using (ie WebIress, the web-based version of the software).

This is, however, possible using the desktop version of the software. They use a separate Execute function that, on double-clicking a cell, executes the function in the cell. This function resides in a separate type library.