CommandBarButton onClick

[virgin69]

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-

 

[Bob Phillips]

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)

 

[virgin69]

Hello Bob,

Thanx Bunches! The ActionControl Property did the trick.



-V-