Thread: Menus using VBA?

Hi Thulasi, try J-Walk's page:
http://j-walk.com/ss/excel/tips/tip53.htm
--
Charles Chickering

"A good example is twice the value of good advice."


"Thulasiram" wrote:

> Hello all,
>
> I have a question..
>
> In visual basic6.0, instead of having lot of commnad buttons in a form,
> they can be included in menus using menu editor.. Is it possible to do
> so in VBA?
>
> I have lot of command buttons here and there in every sheet. But
> operations performed by those macros are not confined to one sheet but
> they are applicable to all sheets in the workbook.. In VB, the user can
> spot the command buttons in a form as one cant scroll a form. But, in
> Excel, there is a possibility to miss a command button that is placed
> near the cell BW5. So, Is it possible to create an extra menu using VBA
> code?
>
> Any suggestions and expert advice is greatly appreciated.
>
> Thanks,
> Thulasiram
>
>

Hello all,

Yes or No to the question below would be great! Any external link that
would give insight on menu editor in VBA would be awesome too..

Any more additional responses would be greatly appreciated too.

Thanks for your time..

Thulasiram wrote:
> Hello all,
>
> I have a question..
>
> In visual basic6.0, instead of having lot of commnad buttons in a form,
> they can be included in menus using menu editor.. Is it possible to do
> so in VBA?
>
> I have lot of command buttons here and there in every sheet. But
> operations performed by those macros are not confined to one sheet but
> they are applicable to all sheets in the workbook.. In VB, the user can
> spot the command buttons in a form as one cant scroll a form. But, in
> Excel, there is a possibility to miss a command button that is placed
> near the cell BW5. So, Is it possible to create an extra menu using VBA
> code?
>
> Any suggestions and expert advice is greatly appreciated.
>
> Thanks,
> Thulasiram

i believe the answer is yes.
i searched "new menu" in the newsgroup & came up with this........
you might find exactly what you need if you search..... i don't know
how to do it and have never tried it.

http://groups.google.com/group/micro...5de777185e6993

susan


Thulasiram wrote:
> Hello all,
>
> Yes or No to the question below would be great! Any external link that
> would give insight on menu editor in VBA would be awesome too..
>
> Any more additional responses would be greatly appreciated too.
>
> Thanks for your time..
>
> Thulasiram wrote:
> > Hello all,
> >
> > I have a question..
> >
> > In visual basic6.0, instead of having lot of commnad buttons in a form,
> > they can be included in menus using menu editor.. Is it possible to do
> > so in VBA?
> >
> > I have lot of command buttons here and there in every sheet. But
> > operations performed by those macros are not confined to one sheet but
> > they are applicable to all sheets in the workbook.. In VB, the user can
> > spot the command buttons in a form as one cant scroll a form. But, in
> > Excel, there is a possibility to miss a command button that is placed
> > near the cell BW5. So, Is it possible to create an extra menu using VBA
> > code?
> >
> > Any suggestions and expert advice is greatly appreciated.
> >
> > Thanks,
> > Thulasiram