Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a divider to an add-in using vba in excel 2007
I have done some research and thought that I had this figured out, but it is
not giving me the result that I am looking for. I am trying to add a divider to a drop down list between different macros. I thought this was done by the BeginGroup property, but it is not adding the divider. I have posted a section of my code below. Can anyone tell me if I am going about this wrong? Any help would be great. Thanks, Jason Set cmdBar = Application.CommandBars("Worksheet Menu Bar") Set cmdBarMenu = cmdBar.Controls.Add(Type:=msoControlPopup, temporary:=True) With cmdBarMenu .Caption = "Tools" .Tag = "JJT" End With Set cmdBarMenuItem = cmdBarMenu.Controls.Add(Type:=msoControlButton) With cmdBarMenuItem .Caption = "Merge" .OnAction = "MergeCells" .Tag = "JJT" .FaceId = 798 End With cmdBarMenu.BeginGroup = True Set cmdBarMenuItem = cmdBarMenu.Controls.Add With cmdBarMenuItem .Caption = "Unmerge" .OnAction = "UnmergeCells" .Tag = "JJT" .FaceId = 800 End With |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a divider to an add-in using vba in excel 2007
See the two <<< notations below...
-- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "test_52" wrote in message I have done some research and thought that I had this figured out, but it is not giving me the result that I am looking for. I am trying to add a divider to a drop down list between different macros. I thought this was done by the BeginGroup property, but it is not adding the divider. I have posted a section of my code below. Can anyone tell me if I am going about this wrong? Any help would be great. Thanks, Jason Set cmdBar = Application.CommandBars("Worksheet Menu Bar") Set cmdBarMenu = cmdBar.Controls.Add(Type:=msoControlPopup, temporary:=True) With cmdBarMenu .Caption = "Tools" .Tag = "JJT" End With Set cmdBarMenuItem = cmdBarMenu.Controls.Add(Type:=msoControlButton) With cmdBarMenuItem .Caption = "Merge" .OnAction = "MergeCells" .Tag = "JJT" .FaceId = 798 End With 'cmdBarMenu.BeginGroup = True '<<<< Not this Set cmdBarMenuItem = cmdBarMenu.Controls.Add With cmdBarMenuItem .Caption = "Unmerge" .OnAction = "UnmergeCells" .Tag = "JJT" .FaceId = 800 .BeginGroup = True '<<<< Do this instead End With |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a divider to an add-in using vba in excel 2007
Thanks a bunch! Figures it was something easy!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple text-number in cell divider formula? | Excel Worksheet Functions | |||
Word destrots the comma as decimal divider in Excel | Excel Discussion (Misc queries) | |||
Change Dots into Commas as Decimal Divider | Excel Discussion (Misc queries) | |||
VBA to add group divider to custom menu | Excel Programming | |||
formula for avarage with a variable divider | Excel Programming |