| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combo box in toolbar
Can this be done in version 20002 (XP)?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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)? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel VBA Combo Box Populating dependent on other combo box choices | Excel Programming | |||
| Filtered list for Combo Box ListFillRange - Nested Combo Boxes | Excel Programming | |||
| Move or Size Combo Box from forms toolbar With Cells | Excel Discussion (Misc queries) | |||
| "Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
| Can you place a combo box in a custom toolbar? | Excel Programming | |||
Linear Mode
