Application.OnDoubleClick

[Dave Unger]

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]

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?

 

[Auric__]

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

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?

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.

 

[Dave Unger]

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...ic.excel.programming/yP0AqgyrGAI/DYKTYYU1Fy4J

http://www.office-archive.com/2-excel/808b73f2928337b0.htm

rgards,

DaveU

 

[Ben McClave]

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/lib...interop.excel._application.ondoubleclick.aspx

http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.application_members.aspx

http://www.mrexcel.com/forum/excel-questions/80816-disabling-double-clicking-excel2002.html

 

[Dave Unger]

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 tofind 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