VBA function for XL add-ins
 

HI

I was wondering if it is possible to code a comand button (on userforms) so that an application add-in that is installed on my excel would work. For example,

My add-in has a pull down menu (next to the standard excel pull downs at the top). When pressed, the first option on the menu is labelled 'calculate'. Now, the VBA code would need to activate this calculate
option.

The add-in manufacturers say that it can be interfaced with VBA, but do not hint at the code.

Has anyone had this problem?

Thanks in advance

VBA function for XL add-ins
 

You can try a variation on the following code:

Application.CommandBars.ActiveMenuBar.Controls("To ols").Controls("Calculate").Execute



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)



"shnim1" wrote in message
...

HI

I was wondering if it is possible to code a comand button (on
userforms) so that an application add-in that is installed on my excel
would work. For example,

My add-in has a pull down menu (next to the standard excel pull downs
at the top). When pressed, the first option on the menu is labelled
'calculate'. Now, the VBA code would need to activate this calculate
option.

The add-in manufacturers say that it can be interfaced with VBA, but do
not hint at the code.

Has anyone had this problem?

Thanks in advance




--
shnim1