Menus using VBA?
 

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

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

Menus using VBA?
 

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

Menus using VBA?
 

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

Menus using VBA?
 

Susan,

Infact, I do so after posting the previous mail.. I landed with some
favorable search results. I too believe that the answer is yes.

Thanks for the link! Its helpful

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