Macro Code required..........?

[Thyagaraj]

Dear Friends,

I need the macro code to get a ListBox or ComboBox when ever Excel
Application is started and to close the same ListBox or ComboBox When
ever the excel application is closed.

If possible I need the code to create a button on that ListBox or
ComboBox and assign a macro to that button.



Thanks in Advance

Thyagaraj Shetty

 

[Jim Thomlinson]

While that is possible to do, it is not simple code to write or understand.
You need to create an add in containing a class to handle the events and an
understanding of forms. If you are comfortable with all of that then reply
back and I can help get you started...

 

[Thyagaraj]

While that is possible to do, it is not simple code to write or understand.
You need to create an add in containing a class to handle the events and an
understanding of forms. If you are comfortable with all of that then reply
back and I can help get you started...

I Am very much Comfortable with all these but I Want the Code to Place
the ListBox or ComboBox on the ToolBar of Excel Application.

Please Hep.


Regards
Thyagaraj

 

[Jim Thomlinson]

Sub test2()
Dim cmd As CommandBarComboBox

Set cmd = Application.CommandBars("Worksheet Menu
Bar").Controls.Add(msoControlComboBox)

End Sub