View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kent Prokopy Kent Prokopy is offline
external usenet poster
 
Posts: 39
Default 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