How to run a commandbar controled module inside a Macro

I have installed an Excel module to translate selected cells into another language. The module is controled by a set of command bars. I want to run the translation module from inside a Macro, but I don't know how. I tried the macro recording, but it did not record any code. Below is part of the translation commandbar module. Can anyone tell me how to run the module from a Macro? Thanks.




Sub LocalizeButtons()

Dim CommandBar As CommandBar
Dim ComboBox As CommandBarComboBox

Set CommandBar = CommandBars("PROMT6 SmarTool")

Set CommandBarControl = CommandBar.FindControl(Tag:="PROMT_ST_DIRECTION")
Set ComboBox = CommandBarControl
ComboBox.Clear
CommandBarControl.Caption = "Direction of Translation"
CommandBarControl.TooltipText = "Direction of Translation"
CommandBarControl.Enabled = True
Set CommandBarControl = Nothing
...

End Sub

Perhaps the attached will help, it has menu & sub menu setup items with easy understanding.

---

Originally Posted by betty77

I have installed an Excel module to translate selected cells into another language. The module is controled by a set of command bars. I want to run the translation module from inside a Macro, but I don't know how. I tried the macro recording, but it did not record any code. Below is part of the translation commandbar module. Can anyone tell me how to run the module from a Macro? Thanks.




Sub LocalizeButtons()

Dim CommandBar As CommandBar
Dim ComboBox As CommandBarComboBox

Set CommandBar = CommandBars("PROMT6 SmarTool")

Set CommandBarControl = CommandBar.FindControl(Tag:="PROMT_ST_DIRECTION")
Set ComboBox = CommandBarControl
ComboBox.Clear
CommandBarControl.Caption = "Direction of Translation"
CommandBarControl.TooltipText = "Direction of Translation"
CommandBarControl.Enabled = True
Set CommandBarControl = Nothing
...

End Sub

Thanks for your reply. I installed your sample file in excel, but I got an error when opening it. After going through the vba code in your file, I still can not figure things out. Would you please explain further how exactly I should do to call the commandbar controlled module using vba code? Thanks.