CommandBarButton onClick

Hola Folks,

environment:
- Excel 2003, VBA, Add-In (XLA)

I have added several menuitems to the Excel menu during the
registration of an add-in. Is there a way to handle onclick events for
the menu items I have added?

Right now, each one of the menu items has a different onaction
subroutine that stores an ID specifying which button was clicked in a
global variable.

In the end, I'd like to hook all of the onclick events for the menu
items that I have added through a single function. Even if they all
have the same function set in their onAction properties, it doesn't
look like I have a method of determining which of the menu items was
clicked.
I'd like to be able to get a handle to the control / menu item and
evaluate whatever is stored in the tag property. The only way I know of
to do this is kludgy and most importantly, doesn't seem to work as
expected across sessions.

I hope this is clear enough to make sense because I'm very tired and
probably not communicating effectively.



-V-

On each menu item, set the Parameter or Tag properies separately, and then
test them in the macro like so

With CommandBars.ActionControl
Select Case .Tag
Case "Val1": 'some actione
Case "Val2": 'some other action
Case Else: 'default action
End Select
End With

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

<[email protected]> wrote in message
news:[email protected]...
> Hola Folks,
>
> environment:
> - Excel 2003, VBA, Add-In (XLA)
>
> I have added several menuitems to the Excel menu during the
> registration of an add-in. Is there a way to handle onclick events for
> the menu items I have added?
>
> Right now, each one of the menu items has a different onaction
> subroutine that stores an ID specifying which button was clicked in a
> global variable.
>
> In the end, I'd like to hook all of the onclick events for the menu
> items that I have added through a single function. Even if they all
> have the same function set in their onAction properties, it doesn't
> look like I have a method of determining which of the menu items was
> clicked.
> I'd like to be able to get a handle to the control / menu item and
> evaluate whatever is stored in the tag property. The only way I know of
> to do this is kludgy and most importantly, doesn't seem to work as
> expected across sessions.
>
> I hope this is clear enough to make sense because I'm very tired and
> probably not communicating effectively.
>
>
>
> -V-
>

Hello Bob,

Thanx Bunches! The ActionControl Property did the trick.



-V-