Hello,

While perusing various groups re "Worksheet_BeforeDoubleClick", I came across a few references/examples to "Application.OnDoubleClick". I tried it out, and it works as expected, but it's a new one to me. I can find no mention of it in the Help, and also can't find it in the Application Object methods - I would expect to see it listed before OnKey, but surprisingly, it's not there. Should I be looking elsewhere for documentation on this?

Regards,

DaveU

hi Dave,

is this a vb method?
can you show us the example you have try?

isabelle

Le 2013-02-01 22:56, Dave Unger a écrit :
Hello,

While perusing various groups re "Worksheet_BeforeDoubleClick",

I came across a few references/examples to "Application.OnDoubleClick".

I tried it out, and it works as expected, but it's a new one to me.

I can find no mention of it in the Help, and also can't find it in the
Application Object methods -

I would expect to see it listed before OnKey, but surprisingly, it's not
there. Should I be looking elsewhere for documentation on this?

Regards,

DaveU

Le 2013-02-01 22:56, Dave Unger a écrit :
Hello,

While perusing various groups re "Worksheet_BeforeDoubleClick",

I came across a few references/examples to "Application.OnDoubleClick".

I tried it out, and it works as expected, but it's a new one to me.

I can find no mention of it in the Help, and also can't find it in the
Application Object methods -

I would expect to see it listed before OnKey, but surprisingly, it's not
there. Should I be looking elsewhere for documentation on this?

Regards,

DaveU

isabelle wrote:

hi Dave,

is this a vb method?
can you show us the example you have try?

isabelle

I second that. Please post links to the examples you've found.

--
- I don't mean to judge, but the new guy's got sort of a serial killer smile.
- Y'know how it goes. The great ones are always a little off.

Hello, thanks for your replies. Interesting, I'm glad I'm not the only one who hasn't heard of this ;-)

Here's a couple of links to threads where this is discussed. The first is by Dave Peterson, the second by Bill Manville, both of whom are recognized VBA experts.

https://groups.google.com/forum/?hl=...I/DYKTYYU1Fy4J

http://www.office-archive.com/2-exce...f2928337b0.htm

rgards,

DaveU

Dave,

I did some digging, but this is the most I could find. The first two are from microsoft, the last is a thread that has a pretty good explanation of how it is used:

http://msdn.microsoft.com/en-us/libr... leclick.aspx

http://msdn.microsoft.com/en-us/libr...members .aspx

http://www.mrexcel.com/forum/excel-q...excel2002.html

On Friday, February 1, 2013 9:56:54 PM UTC-6, Dave Unger wrote:
Hello,



While perusing various groups re "Worksheet_BeforeDoubleClick", I came across a few references/examples to "Application.OnDoubleClick". I tried it out, and it works as expected, but it's a new one to me. I can find no mention of it in the Help, and also can't find it in the Application Object methods - I would expect to see it listed before OnKey, but surprisingly, it's not there. Should I be looking elsewhere for documentation on this?



Regards,



DaveU

Hi Ben,

Thanks for the links, that was helpful. One thing that surprised me was to find out that "Application.OnDoubleClick" is an application "property", not a "method", as I had assumed. However, now that I know that, I still can't find it listed under Help in the Application members properties (either XL2003 or 2010) - I guess it's another one of those "un-documented" items!

Thanks again,

Regards,

Dave