CommandBarButton click vs. double click

[Derrick]

Hello all;

I'm using VSTO 2003, and creating a custom CommandBar for Excel. I want to
be able to distinguish between a single click and a double click of a
CommandBarButton. However, I noticed the CommandBarButton interface only
has a "Click" event.

What I ultimately want to accomplish is equivalent to the Format Painter in
MS Word: click it once, and it "turns off" after use. Double click it, and
it stays pressed ("on").

Any help on how to differentiate between single and double clicks of a
CommandBarButton?

Thanks in advance,

Derrick

 

[Rob Bovey]

I'm using VSTO 2003, and creating a custom CommandBar for Excel. I want
to be able to distinguish between a single click and a double click of a
CommandBarButton. However, I noticed the CommandBarButton interface only
has a "Click" event.

What I ultimately want to accomplish is equivalent to the Format Painter
in MS Word: click it once, and it "turns off" after use. Double click
it, and it stays pressed ("on").

Hi Derrick,

As far as I know, there's no way to do this. The number of things that
you can create/accomplish using custom command bar controls is only a small
subset of the number of things you see Excel and the other Office apps doing
with them.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

 

[Derrick]

Thanks Rob. I was afraid of that.

I managed to "fake it" using a Timer, but it's a bit of a hack. However, in
doing so, I noticed that if you "double-click" a CommandBarButton, you
actually receive 3 (yes, that's THREE) Click events. If you
"quadruple-click", you get 6 events. I guess it is possible that one of
these indicate a double-click, but there is no way to differentiate - at
least as far as I can tell...

Thanks,

Derrick