drop down menus

[Lane]

Can you put a drop down menu on a toolbar?

 

[Bob Umlas]

Yes:

set t=commandbars.Add
t.visible=true
set t2=t.controls.add (msocontroldropdown)
t2.additem "Jan"
t2.additem "Feb"

Bob Umlas
Excel MVP

 

[Lane]

Does that get copy/pasted into a module