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

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

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...
--
HTH...

Jim Thomlinson


"Thyagaraj" wrote:

> 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 wrote:

> 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...
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Thyagaraj" wrote:
>
> > 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
> >
> >
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

Sub test2()
Dim cmd As CommandBarComboBox

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

End Sub
--
HTH...

Jim Thomlinson


"Thyagaraj" wrote:

>
> Jim Thomlinson wrote:
>
> > 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...
> > --
> > HTH...
> >
> > Jim Thomlinson
> >
> >
> > "Thyagaraj" wrote:
> >
> > > 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
> > >
> > >
> 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
>
>