ExcelBanter - combo box in toolbar

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - combo box in toolbar (https://www.excelbanter.com/excel-programming/390140-combo-box-toolbar.html)

Smallweed

combo box in toolbar

Can this be done in version 20002 (XP)?

Andy Pope

combo box in toolbar

Hi,

The help file on topic Controls provides an example.

Set myControl = CommandBars("Custom").Controls _
.Add(Type:=msoControlComboBox, Befo=1)
With myControl
.AddItem Text:="First Item", Index:=1
.AddItem Text:="Second Item", Index:=2
.DropDownLines = 3
.DropDownWidth = 75
.ListHeaderCount = 0
End With

Cheers
Andy

Smallweed wrote:
Can this be done in version 20002 (XP)?

Smallweed

combo box in toolbar

Thanks Andy.

"Andy Pope" wrote:

Hi,

The help file on topic Controls provides an example.

Set myControl = CommandBars("Custom").Controls _
.Add(Type:=msoControlComboBox, Befo=1)
With myControl
.AddItem Text:="First Item", Index:=1
.AddItem Text:="Second Item", Index:=2
.DropDownLines = 3
.DropDownWidth = 75
.ListHeaderCount = 0
End With

Cheers
Andy

Smallweed wrote:
Can this be done in version 20002 (XP)?

All times are GMT +1. The time now is 11:02 PM.