Selecting Menu Item by VBA Code

[Guest]

I have an add-in which adds its own menu to the Excel program. I need to be
able to select a shortcut menu item by VBA to update the information
displayed on the worksheet. This will automate the update process for the
information (otherwise, will need to manually right-click and select the
menuitem ~20 times).

Thanx in advance.

 

[Ron de Bruin]

Hi

Application.CommandBars.FindControl(, 30010).Controls("&Google Search").Execute
This example will run a control on the Help menu for example

Post back with the name of your control and where it is if you need more help
For ID numbers see
http://www.rondebruin.com/menuid.htm

 

[Bob Phillips]

John,

I would have thought that the best way was to set an object variable to the
men u item when creating it

Set myMenuItem =
Application.Commandbars("Standard").Controls.Add(Type:=msoControlButton,temp
orary:=true)
myMenuItem.Caption = "abc"
etc.

Declare myMenuItem as a global object variable, and you can refer to that
anywhere in the code.

--

HTH

RP
(remove nothere from the email address if mailing direct)