Solved: Detect CommandBar button

[Bilby]

Greetings All,

I have a large number of templates with commandbars etc. When a button is clicked it fires a global macro/procedure and alls okay.
What I would like to do is have a common routine, ie create a new paragraph, highlight the clicked buttons graphic and then styles the paragraph using the buttons tag property.

I can do this by cycling through the commandbars collection and checking for the name of the expected commandbar and then checking the specific buttons tag. But what I want is some easier method of identifying the actual commandbar/button that was pressed. Is there some event that is triggered by a commandbutton?

[matthewspatrick]

The ActionControl method of the CommandBars collection returns the most recently clicked control.

[fumei]

The ActionControl method of the CommandBars collection returns the most recently clicked control.Sorry, but that is totally incorrect. It can be used to do so, but ONLY by making the procedure fired by OnAction one that determines this. The OnAction method does NOT return the most recently clicked control.

OnAction returns or sets the name of a Visual Basic procedure that will run when the user clicks or changes the value of a command bar control.

If the procedure used by OnAction say...creates a new paragraph and formats it...then clicking the button will fire THAT procedure. There is absolutely no inherent information gathered on what was the last control clicked.

The example in Help does so......because that is the ONLY thing the buttons do.

OnAction is just a pointer to a procedure. It sets the action to be taken when it is activated. It contains no Property information on which control was activated.

[matthewspatrick]

fumei,

Please reread my post. I suggested ActionControl, not OnAction.

:)

[matthewspatrick]

Another option would be to create a class for your CommandBar controls, and use that class to tap into the Click event for the CommandBarButtons. I helped a person do this a while back, but it turned out to be hideously complicated. Perhaps someone more skilled with classes could have simplified it.

[fumei]

Hi Patrick,

My apologies.....:doh:

Yes, of course you can use the .Tag of ActionControl.....blush...

[matthewspatrick]

Gerry,

No worries :beerchug:

[Bilby]

Yo Patrick

:mbounce:ActionControl ActionControl ra ra ra :mbounce:
I love it! Thanks a lot for that little gem.

Bilby

[matthewspatrick]

Glad that worked out for you, Bilby :thumb