Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add items to VBA-created menu?
I managed to created a custom menu. But I can't find the Add for the new
control to add items under the new menu. Help? Ed Sub AddNewMenu() Dim oCB As CommandBar Set oCB = Application.CommandBars("Worksheet Menu Bar") Dim newMenu As CommandBarControl Set newMenu = oCB.Controls.Add(Type:=10) newMenu.Caption = "MyMenu" newMenu.Enabled = True End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add items to VBA-created menu?
Thank you, Bob. That's got me going.
Ed "Bob Phillips" wrote in message ... Sub AddNewMenu() Dim oCB As CommandBar Set oCB = Application.CommandBars("Worksheet Menu Bar") Dim newMenu As CommandBarControl Set newMenu = oCB.Controls.Add(Type:=10) With newMenu .Caption = "MyMenu" .Enabled = True With .Controls.Add(Type:=msoControlButton) .Caption = "Button1" .FaceId = 29 .OnAction = "macro1" End With With .Controls.Add(Type:=msoControlButton) .Caption = "Button2" .FaceId = 29 .OnAction = "macro2" End With End With End Sub if you want button icons change the faceid property (John Walkenbach has a utility to help you at http://j-walk.com/ss/excel/tips/tip67.htm to help find the values of the FaceIds), -- HTH RP (remove nothere from the email address if mailing direct) "Ed" wrote in message ... I managed to created a custom menu. But I can't find the Add for the new control to add items under the new menu. Help? Ed Sub AddNewMenu() Dim oCB As CommandBar Set oCB = Application.CommandBars("Worksheet Menu Bar") Dim newMenu As CommandBarControl Set newMenu = oCB.Controls.Add(Type:=10) newMenu.Caption = "MyMenu" newMenu.Enabled = True End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formatting the list items for ComboBox created using Forms | Excel Discussion (Misc queries) | |||
Add list to newly created menu | Excel Discussion (Misc queries) | |||
add list to newly created menu | Excel Worksheet Functions | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
Menu item created w/ add-in removed due other add-in | Excel Programming |