Example of a CommandBar Split Button Popup Control

Dec 22, 2011 at 7:49 PM

I would love an example, if possible, of implementing a Split Button Popup Control on a CommandBar.  I've read a couple of forums that state that this may not be possible, but I personally have been able to load a built in control and modify it a little bit.



Dec 23, 2011 at 4:31 PM


i find the following VBA topic: http://peltiertech.com/Excel/CustomDwgCmdBar.html

Set MyPopup = .Controls.Add(Type:=msoControlSplitButtonPopup, Id:=1692)

looks very typical i find. did you mean that?

Dec 25, 2011 at 3:07 PM
Edited Dec 25, 2011 at 3:10 PM

hello again,

i do a test for you and the following code works fine. (based on netoffice excel example09)

Office.CommandBarPopup splitbuttonPopup = (Office.CommandBarPopup)commandBar.Controls.Add(
MsoControlType.msoControlSplitButtonPopup, 1691, System.Type.Missing, System.Type.Missing, true);