Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
making toggle button in xl menu
i need to method making the xl menu button of toggle button type using macro(vba). here is the code, it does not working. Set oMenu = Application.CommandBars(1). _ Controls.Add(Type:=msoControlButtonToggle, Befo=1) With oMenu .Caption = "test" .Style = msoButtonIconAndCaptionBelow .BeginGroup = True End With *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
making toggle button in xl menu
Why not just use the state property of a regular button (msoControlButton).
Thsi will show the button as being either depressed or not... (msoButtonUp or msoButtonDown) Application.CommandBars("ToolBarName").Controls("C ontrolName").State = msoButtonDown -- HTH... Jim Thomlinson "tom taol" wrote: i need to method making the xl menu button of toggle button type using macro(vba). here is the code, it does not working. Set oMenu = Application.CommandBars(1). _ Controls.Add(Type:=msoControlButtonToggle, Befo=1) With oMenu .Caption = "test" .Style = msoButtonIconAndCaptionBelow .BeginGroup = True End With *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding .xla button for Toggle Calculation Button | Excel Programming | |||
How to create a toggle button on the menu? | Excel Programming | |||
Shortcut Menu With Toggle Control | Excel Programming | |||
Toggle Button | Excel Programming | |||
Toggle State on Custom Menu | Excel Programming |