I can create a custom toolbar button which is a combobox (see code below) , but it dosn't seem to have any of the nice autocomplete features that "normal" combobox's have. Also, I don't see any difference between .Style = msoComboNormal and .Style = msoComboLabel. What types of comboboxes/drop-down lists are possible? TIA --Sam
Public Sub AddComboBar()
Dim cbar As CommandBar
Dim ctl As CommandBarControl
Set cbar = CommandBars.Add(Name:="Demo", Position:=msoBarTop, _
cbar.Visible = True
Set ctl = cbar.Controls.Add(Type:=msoControlComboBox)
.Tag = "HL"
.ListIndex = 0 ' Nothing selected
.Style = msoComboNormal
.OnAction = "DoComboBar"