VBA Codes to DoubleClick a cell

[JYY]

I have an excel file with an Essbase add-in. When I doubleclick a cell (eg. Range($C$3)), the excel file will auto retrieve data from database (retrieve and drill down to more detailed data).

I want to have a macro to simplify this routine work, but have no idea on how to mimic the doubleclick action by VBA codes. Anyone can help? Thanks in advance.

[Toonies]

ok this should help you out

http://www.ozgrid.com/forum/showthread.php?t=49050

[JYY]

Thanks Toonies. I checked your link, and it is telling about how to set up a cell to respond to a doubleclick event. That's not what I want.

I already have the Range($C$3) responding to a doubleclick event. This is the Essbase add-in function.

I want some VBA codes to do the doubleclick action to Range($C$3). Hope I get myself clear.

[JYY]

Anybody can help?

[Norie]

Is double clicking a cell the only way you can trigger the code?