View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Wilkinson Chris Wilkinson is offline
external usenet poster
 
Posts: 28
Default Multi-column Dropdown combox on a commandbar

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