CommandBar Activation 1

[DrGreg1408]

Does anyone know how to tell in VBA which button of a custom toolbar has been activated? Is there such a thing as a ActionSource property that provides the caption or index or some other identifier so I can know in VBA which button was clicked? I'm trying to set up one subroutine that will use a Select Case structure to ascertain which button was clicked and then act accordingly.
Thanks

 

[TonyJollans]

[blue]CommandBars.ActionControl[/blue]

is what you are looking for.

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[DrGreg1408]

Thanks Tony,
As often seems to happen, I discovered the solution soon after I asked the question. That does not mean, however, that I rushed to ask the question. I had already spent quite a bit of time looking for the solution--Microsoft's VBA Editor help system is almost useless. It seems that just asking the question on a tech forum has a magical ability to cause the answer to pop up elsewhere. Anyway, thanks for the quick response.
gsw

 

[PHV]

Microsoft's VBA Editor help system is almost useless
I find it useful, provided you use the Object Browser (F2).

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886