PDA

View Full Version : Addin custom controls


AlexD
03-23-2003, 03:45 PM
HI
the next code works to add a standar combobox in
my own toolbar

Dim CB As CommandBar
Dim CB_TEST As CommandBarComboBox

Set CB = Application.CommandBars.Add(Name:="Meine Symbolleiste", _
temporary:=False, Position:=msoBarTop)

Set CB_TEST = CB.Controls.Add(Type:=msoControlDropDown)

Yeah this works ok

But when i try to do the the same procedure to create a
Drop down button control like the fill color or font color at excel
i changed the type param to msoControlButtonDropdown
But doesnt work CB_TEST goes to NULL

The funny thing itīs that microsoft documentation explain that
a combobox type could be msoControlButtonDropdown

can someone help me please
thanks

Juan Pablo G.
05-06-2003, 04:59 PM
Maybe what they meant is that it's available for tehM ! ;)

Actually, I've only been able to use the ControlEdit, ControlDropDown, and the two "standards", Popup and Button...