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
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