Macro assign to ActiveX Combobox

[kangsongwu]

I have ActiveX Combobox and PivotTable Record Macro. In Form control combobox, can link both with Assign Macro. How to find the link in ActiveX Combobox? Or idea for VB code. Thanks!

[romperstomper]

Enter design mode, then right-click the activex control and choose View Code. You can then choose the event you want to trigger your code from the dropdown list at the top right of the code module.

[kangsongwu]

How to trigger the Marco code, May you please give me some details or send me a sample? thanks!

[romperstomper]

When you choose View Code, you should see this by default (the name of the control may be different):

Private Sub ComboBox1_Change()

End Sub

You can put your code inside that routine or, if you have an existing macro, just add

Call macroname

inside the routine.