Multi-column Dropdown combox on a commandbar
Not sure that this can be done. But I guess my question to you is why would
you need more then one column showing off the menu bar? You can only select
one item to execute.
"Chris Wilkinson" wrote:
mhi,
is it possible to have a dropdown combox on a toolbar that has more than one
column of data? I have tried using the following syntax:
dim ctl as commandbarcombobox
set ctl = Commandbars("test").controls.add(Type:=msoControlD ropdown)
ctl.additem "1;first item"
ctl.additem "2;second item"
or
ctl.additem "1,first item"
ctl.additem "2,second item"
but both only give a single column. How would I create a 2 column dropdown
comobobox on a toolbar, then populate it?
thanks in advance,
Chris
|