Creating Combo Type Menu Bar

[ChloeRadshaw]

Just wondering if anyone can shed light on how to create a submenu where only one item in the sub menu can be checked?



Any ideas please?

Thanks

[georgiboy]

Hi,

Do you mean in a form or on a spreadsheet?

[ChloeRadshaw]

Sorry - No I mean inside the excel menu as a new menu item ....

I can already create a menu (using a command bar) and sub menu using a msoControl

Set cbcCutomMenu = cbcCutomMenu.Controls.Add(Type:=msoControlPopup)

What I cannot do is have this behave like a radio menu.....

[Bob Phillips]

I don't think the option button is a menu control type, so you would have to emulate it some way, not necessarily well.

[ChloeRadshaw]

I don't think the option button is a menu control type, so you would have to emulate it some way, not necessarily well.


This is strange - Having a little tick next to the menu items (like the other Excel menus) is not possible?

ie under View in normal Excel you see ticks for "Forumal Bar " - Thats exactly what I would like....

[Bob Phillips]

a tick is not an option button, it just indicates a state for that control.

[Bob Phillips]

If you just want to assign a tick at some point, set the control's State property to msoButtobDown (Up to remove it).

[ChloeRadshaw]

If you just want to assign a tick at some point, set the control's State property to msoButtobDown (Up to remove it).

I could kiss you on both cheeks - Thank you that worked!

[ChloeRadshaw]

So I ve set this up - However in my macro I need to know which button was clicked and then change the .State property....

Does the call back provide an argument?

[Bob Phillips]

What callback?

You have to either save a control variable for the control, or access it via the menu hierarchy.