Macro/VBA to double click on a cell

[jellybean1974]

Hi there

I have a workbook which has several worksheets that I use as source of Data Validation Lists.

The lists get updated when I double click on the 1st item in the list, via an Excel Add-in to database software called Jedox.

I would like the lists to get updated automatically when the workbook is opened, however, when I tried to record a macro of me double clicking on the cell, the VB looks like this

Sub Macro3()
'
' Macro3 Macro
'
    Sheets("OS").Select
    Range("A10").Select
   End Sub

which is just a single click? So then I tried adding Application.DoubleClick

Sub Macro3()
'
' Macro3 Macro
'
    Sheets("OS").Select
    Range("A10").Select
    Application.DoubleClick
End Sub

but that didn't work either. Is this even possible?

Thanks

J

 

[Hui]

A double click is a mouse event
I don't think that can be faked or emulated

I suspect that the double click sets up a named range which is directly below the cell you clicked on
If you look at your Named Formula then double click on a cell and see if one changes to suit the new location you maybe able to setup the range via a named formula
Then execute the program

I'd also suggest posing this question to the software supplier